SQL Server 2008 Analysis Services Training Video: IDENTITY Column s and Inserts

IDENTITY Columns and Inserts - view details
Scott demonstrates working with IDENTITY columns in this video, pointing out some traps to watch for along the way. How should you handle a primary key or unique constraint violation?

Highlights from this video:Sending conflicting instructions to SQL Server on putting values into a column
Can you change the values of an IDENTITY column?
Successfully inserting specific valuesWhy use surrogate key values?
IDENTITY_INSERT
and much more Source: http://www.learnitfirst.com/Course/161/Video/2985/Identity-Columns-Inserts.aspx Course: http://www.learnitfirst.com/Course/161/SQL-Programming-2008.aspx Skill Level: 300 (Intermediate) Length: 11:30 (25.6MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: identity, insert, column, primary key, unique constraint, violiation, value, surrogate

This video comes from the SQL Server 2008 Analysis Services online training course, Transact-SQL Programming: SQL Server 2008/R2. And be sure to check out even more SQL Server Analysis Services training videos.