How to use select union and loop

CREATE TABLE #Temp
(
  <COLUMNS>
)

 DECLARE @position INT
 SET @position = -1

 WHILE(@position < 1)
 BEGIN

    INSERT INTO #Temp (<COLUMNS>)
    SELECT * FROM mytable

    SET @position = @position + 1

 END

 SELECT * FROM #Temp

Source: stackoverflow.com

Similar codes

0 vote337 views1 answer
Sql script to remove default from column
SQL
0 vote336 views1 answer
SQL Hello, [firstname] [lastname]
SQL
62 votes426 views8 answers
Mysql add column
SQL
0 vote319 views1 answer
How to define a non primary composite key in sql
SQL
17 votes333 views4 answers
Show tables sql server
SQL
0 vote315 views1 answer
Mysql in clausule string array
SQL
1 vote335 views1 answer
Mysql previous year
SQL
0 vote306 views1 answer
Datagrip go to line
SQL
1 vote305 views1 answer
Sqlite show columns in table
SQL
0 vote316 views1 answer
Last date for each user sql
SQL