2
Reply

how to auto reset identity value

parthiban karnan

parthiban karnan

Apr 23 2013 7:15 AM
879
I HAVE CREATED IDENTITY VALUE FOR COLUMN ID IN TABLE..

IDENTITY(1,1)..

 

IF I DELETE RECORD ID 11..AND NEW RECORD ..ID IS TAKEN 13 NOT 12..

 

I USE TO RUN SQL QUERY

 

DBCC IDENTCHECK('TABLENAME',RESEED, 11)

EVERY TIME..

 

HOW TO AUTOMATICALLY RESEED COLUMN VLAUE..

 


Answers (2)