利用游标循环：

DECLARE My_Cursor CURSOR --定义游标FOR (SELECT * FROM dbo.Table) --查出需要的集合放到游标中OPEN My_Cursor; --打开游标FETCH NEXT FROM My_Cursor ; --读取第一行数据WHILE @@FETCH_STATUS = 0BEGIN--UPDATE dbo.Table SET 字段1 =‘***’ 　WHERE CURRENT OF My_Cursor; --更新--DELETE FROM dbo.Table WHERE CURRENT OF My_Cursor; --删除FETCH NEXT FROM My_Cursor; --读取下一行数据ENDCLOSE My_Cursor; --关闭游标DEALLOCATE My_Cursor; --释放游标

利用游标赋值循环：

declare @参数1 参数1类型,@参数2 参数2类型DECLARE MyCursor CURSOR --定义游标(利用游标循环)FOR (select 字段1,字段2 from Table) --查出需要的集合放到游标中order by 字段1--排序语句放在括号外OPEN MyCursor; --打开游标FETCH NEXT FROM MyCursor INTO @参数1 ,@参数2;--读取第一行数据WHILE @@FETCH_STATUS = 0Beginif 条件成立 begin--如需跳过当前循环，需先赋值,再continue，否则会进入死循环FETCH NEXT FROM MyCursor INTO @参数1 ,@参数2;continue;--跳过当前循环，进入下一循环endif 条件成立 beginBreak; --跳出整个循环end/* 需要在循环内处理的*** */--PRINT @参数1,参数2; --打印参数值(调试)--UPDATE Table set 字段3=*,字段4=* where 字段1=@参数1 and 字段2=@参数2--Insert into Table1(字段1，字段2) values(参数1,参数2)--Delete from table where 字段1=参数1 and 字段2=参数2FETCH NEXT FROM MyCursor INTO @参数1 ,@参数2; --赋值后进入下一循环EndCLOSE MyCursor; --关闭游标DEALLOCATE MyCursor;--释放游标

类似For循环的ＳＱＬ循环:

declare @itemnumber int --定义需要循环的次数 declare @tagint int --定义标志字段，用于结束循环 set @tagint=1select @itemnumber = count(distinct Creater) from Demo_TestTable where isnull(Creater,'')<>'' And 　DATEDIFF(DAY,CreatDate,GETDATE())<1if(@itemnumber>0) begin while @tagint<=@itemnumber beginwaitfor delay '00:00:01' --每隔一秒再执行 可用参数变量替换 Update Demo_TestTable set CreatDate=GETDATE() where Creater =( Select Creater from ( select Creater,ROW_NUMBER() over(order by Creater) as RowID from Demo_TestTable where isnull(Creater,'')<>'' And DATEDIFF(DAY,CreatDate,GETDATE())<1 group by Creater ) TableAwhereTableA.RowID=@tagint)set @tagint=@tagint+1end end