Articles on Identity

Autonumbering & Identity Columns ( 25 June 2000 - Bill Graziano

Uniqueidentifier vs. IDENTITY ( 12 September 2000 - Sean Baird

Alternatives to @@IDENTITY in SQL Server 2000 ( 19 September 2000 - Sean Baird

Returning @@IDENTITY back to an ASP Page ( 18 August 2000 - Bill Graziano

Identity and Primary Keys ( 28 February 2001 - Rob Volk

Understanding Identity Columns ( 9 March 2002 - Bill Graziano

Using the OUTPUT Clause to Capture Identity Values on Multi-Row Inserts ( 14 August 2006 - Bill Graziano

Custom Auto-Generated Sequences with SQL Server ( 24 April 2007 - Jeff Smith

How to Insert Values into an Identity Column in SQL Server ( 6 August 2007 - Bill Graziano

Efficiently Reuse Gaps in an Identity Column ( 9 February 2010 - Peter Larsson