求一个SQL

[viva369]

求一段sql，要求组成一个9位数字符串，由0和1组成的所有结合
例如：
111111111
010101010

[RINK_1]

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)