sql循环,除了游标还有如下
-- --创建临时表
-- DECLARE @tradeID INT;
--if not object_id('Tempdb..#A') is null
-- drop table #A
--Create table #A([TradeID] nvarchar(100))
--Insert #A SELECT TradeID FROM dbo.CRM_AntiFakeQRec GROUP BY TradeID
--WHILE EXISTS(SELECT TradeID FROM #A)
--BEGIN
--SET ROWCOUNT 1
--SELECT @tradeID=TradeID FROM #A
--SET ROWCOUNT 0
--DELETE FROM #A WHERE TradeID=@tradeID
--PRINT @tradeID