34,838
社区成员




CREATE TABLE #T(NUM VARCHAR(5))
INSERT INTO #T
SELECT '1' UNION ALL
SELECT '0'
DECLARE @I INT
DECLARE @SQL1 VARCHAR(8000)
DECLARE @SQL2 VARCHAR(8000)
SET @I=9
WHILE @I>1
BEGIN
SET @SQL1=ISNULL(@SQL1,'')+'+T'+CAST(@I AS VARCHAR)+'.NUM'
SET @SQL2=ISNULL(@SQL2,'')+'JOIN #T AS T'+CAST(@I AS VARCHAR)+' ON 1=1 '
SET @I=@I-1
END
SET @SQL1='SELECT #T.NUM+'+@SQL1+' FROM #T '+@SQL2
EXEC(@SQL1)