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..