All Articles -> SQL Server Identity

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

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

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

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

Understanding Identity Columns ( 9 March 2002 - Bill Graziano - 7 Comments)

Identity and Primary Keys ( 28 February 2001 - Rob Volk - 147 Comments)

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

Uniqueidentifier vs. IDENTITY ( 12 September 2000 - Sean Baird - 21 Comments)

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

Autonumbering & Identity Columns ( 25 June 2000 - Bill Graziano - 2 Comments)