Welcome to Part 2 of the course. Today, we'll teach you some advanced features of
DELETE operations in T-SQL.
You will learn how to:
- Insert, update, and delete with
- Use the
IS NULL operator in the
WHERE condition of
DELETE statements with complicated conditions.
- Use expressions with mixed columns in
- Display column values during
- Use an
INSERT statement with
SELECT to insert many records with just one query.
We're going to work with some data we've acquired from a university on its official examinations, which include written and oral exams. In the oral exam, points are often recorded immediately, while the written exam's result is recorded after the exam has been scored by the teacher.
Let's find out more.