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
1. Welcome
Default values
How to auto-generate values in a database
Summary

Instruction

Welcome to Part 3 of the How to insert, update, or delete data in SQL Server course. Today, we're going to deal with auto-filling values in INSERT, UPDATE, and DELETE statements.

You'll find out how and why to use the DEFAULT value in these statements. You'll also become familiar with the auto-generation of values in tables and databases. You'll learn how to use IDENTITY, SEQUENCE, and the NEWID() function.

Let's get started!

Exercise

Click Next exercise to continue.