Delete selected rows MSSQL

2 posts

[expired user #9294] posted 9 years ago in General

Hi everyone,

ID
1 Michael
2 John
3 David
4 Sally

If i delete second row (2 John) table

1 Michael
3 David
4 Sally

I want the table to be consecutively numbered

1 Michal
2 David
3 Sally

Can you help me ? If i edit the id manually it says identity field cannot be updated

1 posts

[expired user #9308] posted 9 years ago

Try use....ADO.Net

Biden

Please login to leave a reply, or register at first.