New Transact SQL Video Tutorial: Part 1 - Identity Columns - When Should I Use an Identity Column?

Part 1 - Identity Columns - When Should I Use an Identity Column? - view details

IDENTITY columns are some data modeler's Best Friend yet others avoid them like the plague in favor of "Natural Keys" only and/or GUIDs. This video, part one in a series, walks you through the if, ands, and buts of using IDENTITY columns, points out some suggested use of IDENTITY columns and finished with a few Gotchas of using IDENTITY columns.

---

• Source: Transact SQL videos
• Category: Table Design - Datatypes, Constraints, IDENTITY Columns, Normalization, and More
• Skill Level: 100 (Beg inner)
• Length: 19:05 (14.1MB)
• Applies to Versions: SQL Server - All Versions
• Full Details

---

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: identity, update identity, autonumber, auto-number, auto number, seed, increment, beginner, beginning, for beginners, introducti