sql server 脚本 游标的使用

原文链接：http://www.fengyachao.com/archives/57

declare @zorder int,@a001000 varchar(20),@a001000temp varchar(20),@id int

set @zorder = 1
set @a001000temp = '@#$%'
declare cur Cursor for
select a001000,id from table_name order by a001000,zorder
open cur
fetch next from cur into @a001000,@id
while @@fetch_status=0
begin
if(@a001000temp != @a001000)
begin
set @zorder = 1
set @a001000temp=@a001000
end
update table_name set zorder=@zorder where a001000=@a001000 and id=@id
set @zorder=@zorder+1
fetch next from cur into @a001000,@id
end
close cur
deallocate cur