存档

文章标签 ‘sql server’

sql server 脚本 游标的使用

2011年5月10日 没有评论 2,617 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
分类: 数据库 标签: