DECLARE @Id varchar(50) DECLARE My_Cursor CURSOR --定義游標 FOR (SELECT Id FROM dbo.kinpanAwardProject where session=9) --查出需要的集合放到游標中 OPEN My_Cursor; --打開游標 FETCH NEXT FROM My_Cursor INTO @Id; --讀取第一行數(shù)據(jù)(將Id放到@Id變量中) WHILE @@FETCH_STATUS = 0 BEGIN PRINT @Id; --打印數(shù)據(jù)(Id) UPDATE dbo.kinpanAwardProject SET ProTicketCount = cast( floor(rand()*30) as int)+40 WHERE Id = @Id; --更新數(shù)據(jù)，使用隨機數(shù)。 FETCH NEXT FROM My_Cursor INTO @Id; --讀取下一行數(shù)據(jù)(將查詢的Id放到@Id變量中) END CLOSE My_Cursor; --關(guān)閉游標 DEALLOCATE My_Cursor; --釋放游標 GO
DECLARE My_Cursor CURSOR --定義游標 FOR (SELECT * FROM dbo.MemberAccount) --查出需要的集合放到游標中 OPEN My_Cursor; --打開游標 FETCH NEXT FROM My_Cursor ; --讀取第一行數(shù)據(jù) WHILE @@FETCH_STATUS = 0 BEGIN --UPDATE dbo.MemberAccount SET UserName = UserName + 'A' WHERE CURRENT OF My_Cursor; --更新 --DELETE FROM dbo.MemberAccount WHERE CURRENT OF My_Cursor; --刪除 FETCH NEXT FROM My_Cursor; --讀取下一行數(shù)據(jù) END CLOSE My_Cursor; --關(guān)閉游標 DEALLOCATE My_Cursor; --釋放游標 GO
