用cte创建while循环

山西雁徐良

如何从while循环中创建sql server cte
这样的循环
+ `! K$ I- v0 b- H4 n+ \, A3 y) {; S  declare @ind as int
  declare @code as nvarchar
9 k* n0 l, y+ x' _; m( C1 r  set @ind  = 0
   while @ind 如果需要表：
) ]5 J- {& J; h2 ?2 f+ L;WITH Sec(Number) AS
(
    SELECT 0 AS Number
- a; i- ^* S# q    UNION ALL
- p9 f* n1 O" h    SELECT Number + 1
& ]" b7 Z9 N! v    FROM Sec
3 m2 b0 s: a- L0 Y    WHERE Number 如果您需要一个字符串：
;WITH Sec(Number) AS
(
, ~) e$ s6 n# p    SELECT 0 AS Number
% L; C3 K9 J% L# B    UNION ALL
, G4 X* A  R4 Q    SELECT Number + 1
' x2 N' b4 w* \% P    FROM Sec
$ ?5 t- @$ a. I# M  @    WHERE Number < 884
9 Z& q6 E) Q' a3 ^6 f( z% V' R)
SELECT STUFF(a.[Str], 1, 1, '')
FROM
3 V# U. a& q/ V(
$ e+ E% r: G" Q5 C3 i$ q    SELECT (SELECT ',' + CAST(Number AS NVARCHAR(3))
    FROM Sec
    FOR XML PATH(''), TYPE
2 B2 X% M1 j4 [/ P0 R3 Y    ).value('.','varchar(max)') AS [Str]
) AS a
OPTION(MAXRECURSION 0)