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 vote183 views1 answer
Sql dcl
SQL
0 vote162 views1 answer
Zsh-syntax-highlighting zsh-autosuggestions
SQL
0 vote199 views1 answer
Remove mysql from centos 7
SQL
0 vote165 views1 answer
Incorrect string value: '\xC4\x81ne' for column
SQL
22 votes183 views3 answers
SQL CHEATSHEET
SQL
0 vote186 views1 answer
Regex any word except sql
SQL
0 vote242 views1 answer
How to show current database in mysql
SQL
22 votes229 views1 answer
Mysql workbench
SQL
0 vote173 views1 answer
Grepper sql workbench download
SQL
2 votes208 views3 answers
Xampp mysql database not starting
SQL