摘要:
方法一:SELECT * INTO #t1 FROM dbo.HorseBaseDECLARE @id intDECLARE @t2 table (id int)WHILE (exists(SELECT HorseNumber FROM #t1))BEGINSELECTTOP 1 @id=HorseNumber FROM #t1INSERT INTO @t2 SELECT HorseNumber FROM #t1 WHERE HorseNumber=@idDELETE FROM #t1 WHERE HorseNumber=@idENDDROP Table #t1方法二:DECLARE @r i 阅读全文