New posts in Identity

Add autoincrement to existing PK

Change IDENTITY_INSERT to ON in SQL server

Best way to get last identity inserted in a table

Unexpected gaps in IDENTITY column

Identity column as clustered index bad idea?

Reset IDENTITY value

How to insert in a table with only an IDENTITY column?

How to get last identity row Inserted when using instead of trigger

Identity Columns or UDF that explicitly generates a unique id?

How do I copy a table with SELECT INTO but ignore the IDENTITY property?