Thanks for your reply,
But I want to do it in a single update statement. Not by using identity column. Hint I got is we have to use "Recursion" . But I am not getting how to use recursion concept over here.
omkarkapashikar
Last Activity: Nov 13 '08, 08:35 AM
Joined: Aug 25 '08
Location:
-
-
Recursive Update Query for SQL server
Hi,
I have a table with id and name as column like below.
Id Name
0 a
0 b
0 C
table can have n rows. All n rows contain 0 as id. Now I want to update table such as id column increment like 1,2,3 ,4 for every row.
I want to do that in single update statement...
No activity results to display
Leave a comment: