- Identity (or AutoNumber) is a column that automatically generates numeric values.
- A start and increment value can be set, but most DBA leave these at 1.
- A GUID column also generates numbers; the value of this cannot be controlled.
- Identity/GUID columns do not need to be indexed.
- SELECT @@IDENTITY - returns the last IDENTITY value produced on a connection
- SELECT IDENT_CURRENT ('tablename') - returns the last IDENTITY value produced in a table
- SELECT SCOPE_IDENTITY() - returns the last IDENTITY value produced on a connection.
Book Review: Big Red - Voyage of a Trident Submarine
I've grown up reading Tom Clancy and probably most of you have at least seen Red October, so this book caught my eye when browsing used books for a recent trip. It's a fairly human look at what's involved in sailing on a Trident missile submarine...
2009-03-10
1,439 reads