an identity column and populate it with a few rows: — Create a test table. CREATE TABLE TestIdentityGaps ( ID int IDENTITY PRIMARY KEY, Description varchar (20) ) GO — Insert some values.

SQL Server Drill Down SQL Server Drill Down explores all aspects of Microsoft SQL Server and related applications, with a particular emphasis on issues of interest to SQL Server data professionals.