-
identity column
Hi
I am using SQL Server 2005.
I created a table and i defined an identity column. So whenever i enter any values to my table, the values in identity column keep on increasing like 1,2,3,4,5 on its own.
but when i delete, say, row no. 5 and insert a row again after deleting, the numbering in identity column will be like 1,2,3,4,6.
but i want it it to be 1,2,3,4,5 again. I hope i have made myself clear.
does anyone have the solution for this!!!!
Thanks!!!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|