|
Using @@Identity
(Watch it Later!)
|
|
Date Featured: February 09, 2010
Length: 3 Minutes 23 Seconds
Rating: 4.29
Description: The @@Identity function has been baked into SQL Server for a long time, used to return the latest value generated when a row ...
|
|
|
Using a Server Trigger to Dropping a Database
(Watch it Later!)
|
|
Date Featured: February 08, 2010
Length: 3 Minutes 46 Seconds
Rating: 4.10
Description: This video shows how you can create a server trigger in SQL 2008 to log and/or prevent dropping a database. It's a great into...
|
|
|
Setting the Identity Property of a Column
(Watch it Later!)
|
|
Date Featured: February 05, 2010
Length: 5 Minutes 1 Seconds
Rating: 4.35
Description: SQL provides the identity property to give us the ability to have a column that auto increments (auto number) and it's very e...
|
|
|
Using the Identity Function
(Watch it Later!)
|
|
Date Featured: February 04, 2010
Length: 1 Minutes 52 Seconds
Rating: 4.28
Description: This is very much a niche technique, a way to add a column that has the identity property set when you create a table using S...
|
|
|
Using Identity Insert to Insert Rows
(Watch it Later!)
|
|
Date Featured: February 02, 2010
Length: 2 Minutes 32 Seconds
Rating: 4.47
Description: If you've ever worked with a table that includes a column that is set to an identity (auto number) you know that happiness is...
|
|