用cte创建while循环
如何从while循环中创建sql server cte这样的循环
declare @ind as int
declare @code as nvarchar
set @ind= 0
while @ind 如果需要表:
;WITH Sec(Number) AS
(
SELECT 0 AS Number
UNION ALL
SELECT Number + 1
FROM Sec
WHERE Number 如果您需要一个字符串:
;WITH Sec(Number) AS
(
SELECT 0 AS Number
UNION ALL
SELECT Number + 1
FROM Sec
WHERE Number < 884
)
SELECT STUFF(a., 1, 1, '')
FROM
(
SELECT (SELECT ',' + CAST(Number AS NVARCHAR(3))
FROM Sec
FOR XML PATH(''), TYPE
).value('.','varchar(max)') AS
) AS a
OPTION(MAXRECURSION 0)
页:
[1]