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

Recursive Queries in MS SQL Server

Introduction
3. The Product table
CTEs with data modifying statements
Summary

Instruction

OK. Now the second table: Product. It contains details about the items sold in the grocery stores.

Exercise

Select all the information from the Product table. This table consists of the columns:

  • Id – the identifier of the product/grocery store combination,
  • Name – the name of the product,
  • Price – the price of the product,
  • GroceryStoreId – the ID of the grocery store in which the product is stocked.