Home > database >  O a SQL
O a SQL

Time:09-15

For a period of SQL, requirements of a 9 digit string, consisting of 0 s and 1 s all combined with
For example:
111111111
010101010

CodePudding user response:

 
The 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)

The SET @ I=9

WHILE @ I> 1
The BEGIN

The 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'

The SET @ I=@ I - 1

END

SELECT the SET @ SQL1='# T.N UM +' + @ SQL1 + 'FROM # T + @ SQL2

The EXEC (@ SQL1)
  • Related