1. Welcome
Default values
How to auto-generate values in a database


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!


Click Next exercise to continue.