用cte创建while循环

山西雁徐良

如何从while循环中创建sql server cte
这样的循环
  declare @ind as int
/ n) C, T) b- V5 v! W  declare @code as nvarchar
  set @ind  = 0
   while @ind 如果需要表：
;WITH Sec(Number) AS
(
+ }7 ?: A8 W1 y7 K" o) o0 l    SELECT 0 AS Number
0 Z4 u5 i+ V# V" R8 t# e    UNION ALL
    SELECT Number + 1
    FROM Sec
( Z' a; P- M' X    WHERE Number 如果您需要一个字符串：
/ x7 p' ?6 P/ t8 Y;WITH Sec(Number) AS
8 ?7 s+ a3 Y, e(
5 Z& t: J( s) ]2 `, E    SELECT 0 AS Number
5 h. j' Q" x( S: {5 m7 z    UNION ALL
0 D* i7 N' h& M4 @) x7 f1 ~    SELECT Number + 1
% f3 u) E  ^, [, a) j6 i; _3 |9 o    FROM Sec
    WHERE Number < 884
4 K. @) U, ~) w% c9 ~- |! M2 O)
SELECT STUFF(a.[Str], 1, 1, '')
FROM
(
; D, K: P+ I  E6 [* Z* G; e    SELECT (SELECT ',' + CAST(Number AS NVARCHAR(3))
' e# `/ H& |9 h$ s6 o    FROM Sec
1 z  v7 C0 Z( v* m6 r: R8 X4 N0 `    FOR XML PATH(''), TYPE
    ).value('.','varchar(max)') AS [Str]
) AS a
OPTION(MAXRECURSION 0)