MSSQL Programming and Query Writing Video Tutorial: Auto-Numberin g Rows with IDENTITY Columns - How Identity Columns Work

Auto-Numbering Rows with IDENTITY Columns - How Identity Columns Work - view details

This video is mainly an architecture/sysinternals type of video designed to show you how things work "behind the scenes" with IDENTITY columns. You'll learn how SQL Server chooses the values, how you can influence those values as well as tips and tricks for using IDENTITY columns and Best Practices. IDENTITY columns (and all surrogate keys) are often easy to use but not completely understand by new users. If you use IDENTITY columns in your databases then you'll appreicate this thorough treatment of how IDENTITY columns work in SQL Server.

---

• Source: http://www.learnitfirst.com/Course/150/Video/398/How-IDENTITY-Columns-Work-and-Auto-Numbering-Rows.aspx
• Course: http://www.learnitfirst.com/Course/150/SQL-2005-Programming.aspx
• Skill Level: 200 (Beginner - Intermediate)
• Length: 8:12 (6.31MB)
• Full Details

---

To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: IDENTITY, auto number, sequence, surrogate key, alternate key

This video comes from the SQL Server Programming and Queries online training course, SQL Server Programming (SQL Server 2005/2000): Transact SQL. And be sure to check out even more MSSQL Programming and Query Writing training videos.