Declare Up_Code_Cursor Cursor for select code from table for update Declare @code varchar(50),@i int set @i = 1 open Up_Code_Cursor fetch Next from Up_Code_Cursor into @code while @@fetch_status = 0 begin update table set code = right('0000'+cast(@i as varchar),4) from up_Code_Cursor select @i = @i + 1 fetch Ne...
