Reset Column Identity in SQL Server

There are 2 ways to reset column identity in SQL Server:

  1. Using DBCC CHECKIDENT. Executing below statement in Management Studio will reset the identity column value for the Customer table to 0 so that next new record start at 1.
  2. Using TRUNCATE TABLE statement.
    TRUNCATE TABLE removes all rows from a table or specified partitions of a table, without logging the individual row deletions. TRUNCATE TABLE is similar to the DELETE statement with no WHERE clause; however, TRUNCATE TABLE is faster and uses fewer system and transaction log resources.

T-SQL Quick Tutorial

This is a very quick T-SQL tutorial to get you up and running quickly as a beginner.

Creating Database and Working with Tables

Contraints

Stored Procedures

 

SQL Server Version & Build Number List

Microsoft SQL Server Version and Build Number List

Below is unofficial Microsoft SQL Server version or build number list.

SQL Server Version Version/Build Number
SQL Server 2016 RTM 13.0.1601.5
SQL Server 2014 SP2 12.0.5000.0
SQL Server 2014 SP1 12.0.4100.1
SQL Server 2014 RTM 12.0.2000
SQL Server 2012 SP3 11.0.6020.0
SQL Server 2012 SP2 11.0.5058
SQL Server 2012 SP1 11.0.3000
SQL Server 2012 RTM 11.0.2100
SQL Server 2008 R2 SP3 10.50.6000.29
SQL Server 2008 R2 SP2 10.50.4000
SQL Server 2008 R2 SP1 10.50.2500
SQL Server 2008 R2 RTM 10.50.1600
SQL Server 2008 SP4 10.0.6000
SQL Server 2008 SP3 10.0.5500
SQL Server 2008 SP2 10.0.4000
SQL Server 2008 SP1 10.0.2531
SQL Server 2008 RTM 10.0.1600.29
SQL Server 2005 SP4 9.00.5000.00
SQL Server 2005 SP3 9.0.4035
SQL Server 2005 SP2 9.0.3042
SQL Server 2005 SP1 9.0.2047
SQL Server 2005 RTM 9.0.1399.06
SQL Server 2000 SP4 8.0.2039
SQL Server 2000 SP3 8.0.760
SQL Server 2000 SP2 8.0.532
SQL Server 2000 SP1 8.0.384
SQL Server 2000 RTM 8.0.194
SQL Server 7.0 SP4 7.0.1063
SQL Server 7.0 SP3 7.0.961
SQL Server 7.0 SP2 7.0.842
SQL Server 7.0 SP1 7.0.699
SQL Server 7.0 RTM 7.0.623