Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

How to Insert, Update, or Delete Data in MS SQL Server

Introduction
3. The Exam table
Inserting and updating NULLs
Conditions in UPDATE and DELETE
Using values from another column
Return rows in INSERT, UPDATE, DELETE
Summary

Instruction

The last table, Exam, contains information about all the exams taken by each student at the university.

Exercise

Select all columns from the Exam table. Each exam in the table:

  • Has an identifier (Id).
  • Corresponds to a student (StudentId).
  • Has a related subject (Subject).
  • Has a date (WrittenExamDate and OralExamDate).
  • Has a score (WrittenExamScore and OralExamScore).
  • Has a date when it was scored by the instructor (WrittenScoreDate and OralScoreDate).

Subjects can have a written exam only, an oral exam only, or both written and oral exams.