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 vote190 views1 answer
Change redo log file size in mysql 5.6
SQL
0 vote145 views3 answers
Select random sql
SQL
0 vote136 views1 answer
Separator mysql
SQL
0 vote139 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL
5 votes160 views1 answer
Oracle nls instance
SQL
0 vote150 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
2 votes186 views1 answer
Oracle insert or update
SQL
0 vote175 views1 answer
Compress sql file database ubuntu
SQL
0 vote144 views1 answer
Can't connect to postgresql mac os
SQL
8 votes174 views4 answers
Reset SQL auto increment
SQL