I create one auto incremented column i.e id, by adding data, it incremented by 1,
e.g ..id..
1
2
3
and if i delete all rows then, value not set to 0 , it starts increment as follows,
e.g ..id..
4
5
6
how to solve ?
Joginder BangerPosted Nov 15, 2014, 12:29 AM
DBCC CHECKIDENT (your table name, RESEED, 0)
Dipankar BiswasPosted Nov 14, 2014, 8:53 AM
Ck this link...
http://stackoverflow.com/questions/510121/reset-autoincrement-in-sqlserver-after-delete
................................................................................