TSQL不用游标的循环方法

方法一： SELECT * INTO #t1 FROM dbo.HorseBase DECLARE @id int DECLARE @t2 table (id int) WHILE (exists(SELECT HorseNumber FROM #t1)) BEGIN SELECT TOP 1 @id=HorseNumber FROM #t1 INSERT INTO @t2 SELECT HorseNumber FROM #t1 WHERE HorseNumber=@id DELETE FROM #t1 WHERE HorseNumber=@id END DROP Table #t1 方法二：...