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 Dish table
Inserting data
Modifying data
Deleting data
CRUD

Instruction

Great! As you can see, the Dish table contains information about meals in a restaurant whose owners couldn't decide on a single cuisine, so they basically put everything together.

In this digitized menu, each Dish has a unique Id, a specific Type (there are starters, main courses and desserts), a Name that tells you what it actually is, and a certain Price that is an integer number.

Hungry? Well, before you have something to eat, let's find out how to operate on the data.

Exercise

Click Next exercise to continue.