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

1 vote207 views1 answer
Mysql query bulk insert
SQL
3 votes249 views2 answers
Funktion LOWER/UPPER sql
SQL
1 vote187 views1 answer
Set all the vluses in calumn in sql to false
SQL
0 vote190 views1 answer
Oracle dynamic select into
SQL
0 vote248 views5 answers
Select concat alter table mysql
SQL
2 votes242 views1 answer
Tcl in sql
SQL
0 vote188 views2 answers
Mysql password error create datbase
SQL
0 vote159 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
6 votes196 views1 answer
Oracle desc table primary key
SQL
0 vote205 views1 answer
Mariadb maximum left join
SQL