Declare UpdateNoCursor as cursor for
select no,name,age from YourTableName
declare @NoVal INT
set @NoVal=100
open UpdateNoCursor
fetch next from UpdateNoCursor
while @@fetch_status=0
begin
update YourTableName set no=convert(char(3),@NoVal)
fetch next from UpdateNoCursor
set @NoVal=@NoVal+1
end
close UpdateNoCursor
deallocate UpdateNoCursor
Declare UpdateNoCursor as cursor for
select no,name,age from YourTableName
declare @NoVal INT
set @NoVal=100
open UpdateNoCursor
fetch next from UpdateNoCursor
while @@fetch_status=0
begin
update YourTableName set no=@NoVal
fetch next from UpdateNoCursor
set @NoVal=@NoVal+1
end
close UpdateNoCursor
deallocate UpdateNoCursor