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 vote139 views1 answer
Denied
SQL
1 vote207 views1 answer
Oracle columns table
SQL
13 votes189 views5 answers
Sql default
SQL
0 vote177 views1 answer
Update set with inner join oracle
SQL
37 votes176 views3 answers
Postgresql insert column
SQL
9 votes187 views1 answer
Alter table column change data type to text mysql
SQL
0 vote174 views1 answer
Oracle date summer time
SQL
21 votes198 views1 answer
SQL cheat sheet pdf
SQL
0 vote161 views1 answer
Lister les index d'une table oracle
SQL
0 vote179 views1 answer
Do postgresql
SQL