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 vote188 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
0 vote211 views1 answer
How to alter length character varying postgres
SQL
6 votes194 views3 answers
Mysql first day of year
SQL
0 vote345 views2 answers
Create fulltext index mysql
SQL
2 votes182 views1 answer
Get first 3 letters name in sql
SQL
0 vote182 views3 answers
How to verify sequence result in oracle SQL
SQL
0 vote162 views1 answer
Store query result in variable sql
SQL
5 votes184 views2 answers
Oracle to_timestamp
SQL
5 votes264 views1 answer
FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning.
SQL
1 vote240 views1 answer
Oracle repeat_interval 5 minutes
SQL