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
2. The Student table
Inserting and updating NULLs
Conditions in UPDATE and DELETE
Using values from another column
Return rows in INSERT, UPDATE, DELETE
Summary

Instruction

Let's check out the first table, Student.

Exercise

Select all columns from the Student table. It's a pretty small table that contains only four columns:

  • The student identifier (Id).
  • The first name of the student (FirstName).
  • The middle name of the student (MiddleName).
  • The last name of the student (LastName).

Note: Not every student has a middle name.