如果需要表:
;WITH Sec(Number) AS ( SELECt 0 AS Number UNIOn ALL SELECT Number + 1 FROM Sec WHERe Number < 884)SELECt * FROM SecOPTION(MAXRECURSION 0)
如果您需要一个字符串:
;WITH Sec(Number) AS ( SELECt 0 AS Number UNIOn ALL SELECT Number + 1 FROM Sec WHERe Number < 884)SELECt STUFF(a.[Str], 1, 1, '')FROM( SELECt (SELECT ',' + CAST(Number AS NVARCHAr(3)) FROM Sec FOR XML PATH(''), TYPE ).value('.','varchar(max)') AS [Str] ) AS aOPTION(MAXRECURSION 0)


