About sql server stored procedure for updating serial no column

Jul 29 2011 2:06 AM

Hello everyone
I have one integer column of serial no in sql server table.
I am inserting values in it by incrementing from last one by 1
I want query such as
when i delete any one record from dot net front end then sr nos greater than that no should get decrease by one
Hope you understand

please help