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 Customer table
INSERT with SELECT
Referring to other tables
INSERT, UPDATE and DELETE with JOIN
INSERT, UPDATE, and DELETE with subqueries
Summary

Instruction

The second table, Customer, contains details about the people who buy our products.

Exercise

Select all columns from the Customer table. Its columns are:

  • Id – a unique ID number for each customer.
  • FirstName – the first name of the customer.
  • LastName – the last name of the customer.