Fun with IDENTITY - Part I

What will be the output of the following?

What identity comes next?

Using IDENTITY as a key column

Script to check current identity of Tables

Used to check all current identities on all user tables

Efficiently Reuse Gaps in an Identity Column

This article will demonstrate an efficient way to reuse gaps in an identity column. Please note that this is something you normally shouldn't be bothered about in a well-designed database or application. However, there are circumstances where you are forced to do this.

Retrieving Identities on set-based inserts

Learn a foolproof way to get identity values for multi-row inserts with the OUTPUT clause in SQL Server 2005 without using a cursor.

Identity

TRUNCATE vs DELETE