sql server 脚本 游标的使用
2011年5月10日
2,449 views
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