Code Title: Identity Column in SQL Server
Language: SQL Server
Version: 2005
Database: MS SQL

Description:

To reset the identity value, we can use CHECKIDENT function, so the new record starts at 100000.

 

Added: 02/06/2010

Profile: Syed
User Name: syed

Recent Entries by Author:
Coming Soon!

Note: Please, always give credit to author for his/her work, if used in production environment.