SQL Server IDENTITY Columns

Moved to http://beyondrelational.com/blogs/jacob/archive/2009/03/09/sql-server-identity-columns.aspx

SQL Server IDENTITY Columns - A few more interesting facts

Moved to http://beyondrelational.com/blogs/jacob/archive/2009/03/08/sql-server-identity-columns-a-few-more-interesting-facts.aspx

SQL Server - IDENTITY related functions, commands, system variables, catalog views

Moved to http://beyondrelational.com/blogs/jacob/archive/2009/02/12/sql-server-identity-related-functions-commands-system-variables-catalog-views.aspx

SQL Server - IDENTITY property and IDENTITY() function

This article is moved to http://beyondrelational.com/wikis/dbengine/sql-server-identity-property-v-s-identity-function.aspx

SQL Server - How to retrieve the identity values generated by a multi-row insert?

Moved to http://beyondrelational.com/blogs/jacob/archive/2009/02/06/sql-server-how-to-retrieve-the-identity-values-generated-by-a-multi-row-insert.aspx

SQL Server - @@IDENTITY, SCOPE_IDENTITY() and IDENT_CURRENT()

Moved to http://beyondrelational.com/blogs/jacob/archive/2009/02/05/sql-server-identity-scope-identity-and-ident-current.aspx

SQL Server - How to find out the SEED and INCREMENT values of an IDENTITY column?

Moved to http://beyondrelational.com/blogs/jacob/archive/2009/02/03/sql-server-how-to-find-out-the-seed-and-increment-values-of-an-identity-column.aspx

SQL Server - IDENTITY - Why do I have duplicate identity values?

Moved to: http://beyondrelational.com/blogs/jacob/archive/2009/02/03/sql-server-identity-why-do-i-have-duplicate-identity-values.aspx

SQL Server - How do I Insert an explicit value into an IDENTITY column? How do I Update the value of an IDENTITY Column?

Moved to : http://beyondrelational.com/blogs/jacob/archive/2009/01/30/sql-server-how-do-i-insert-an-explicit-value-into-an-identity-column-how-do-i-update-the-value-of-an-identity-column.aspx

SQL Server - IDENTITY - How to change/reset the IDENTITY values?

Moved to http://beyondrelational.com/blogs/jacob/archive/2009/01/30/sql-server-identity-how-to-change-reset-the-identity-values.aspx

SQL Server - My IDENTITY values are not sequential! Why do I have missing numbers in the IDENTITY column?

Moved to http://beyondrelational.com/blogs/jacob/archive/2009/01/29/sql-server-my-identity-values-are-not-sequential-why-do-i-have-missing-numbers-in-the-identity-column.aspx

SQL Server - Restrictions on the SEED and INCREMENT values of an IDENTITY column

Moved to http://beyondrelational.com/blogs/jacob/archive/2009/01/29/sql-server-restrictions-on-the-seed-and-increment-values-of-an-identity-column.aspx

SQL Server - How to create an Auto-number (IDENTITY) column that counts backwards?

Moved to http://beyondrelational.com/blogs/jacob/archive/2009/01/28/sql-server-how-to-create-an-auto-number-identity-column-that-counts-backwards.aspx

SQL Server - What are the data types supported in IDENTITY columns?

Moved to http://beyondrelational.com/blogs/jacob/archive/2009/01/28/sql-server-what-are-the-data-types-supported-in-identity-columns.aspx

How to create an Auto-number column in SQL Server?

Moved to http://beyondrelational.com/blogs/jacob/archive/2009/01/27/how-to-create-an-auto-number-column-in-sql-server.aspx