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

2 votes334 views2 answers
Select multiple tables mysql
SQL
-1 vote361 views2 answers
Sql convert date to string yyyy-mm-dd
SQL
1 vote364 views1 answer
Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SQL
1 vote388 views1 answer
Sql string function update replace
SQL
0 vote340 views1 answer
Insert or update cassandra
SQL
0 vote355 views1 answer
Sqlite3 get data from table c
SQL
0 vote355 views1 answer
Can't connect to postgresql mac os
SQL
1 vote372 views1 answer
Mysql check string don't have number
SQL
9 votes358 views1 answer
Sql server get utc date
SQL
0 vote372 views1 answer
Xampp increame mysql speed
SQL