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

Instruction

Finally, we come to the last table, Purchase. Let's explore it.

Exercise

Select all columns from the Purchase table. In this store, each purchase is for one kind of product. It consists of the following columns:

  • Id – uniquely identifies each order.
  • ProductId – the ID of the product included in the order.
  • Quantity – how many of each product is in the order.
  • TotalPrice – the total amount for those products.
  • CustomerId – the ID of the customer who bought the order.
  • EmployeeId – the ID of the employee who sold the order.
  • OrderDate – the date on which the order was placed.
  • IsCompleted – a boolean value denoting if the purchase was completed (1) or not (0). Note that the values are displayed as true and false, respectively.