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 vote205 views1 answer
Sql server sleep
SQL
0 vote188 views1 answer
Sql max min
SQL
0 vote191 views1 answer
Oracle flush Shared Pool
SQL
10 votes192 views2 answers
Forgot my mysql password mac
SQL
0 vote195 views1 answer
Opening xampp mysql in cmd ubuntu
SQL
0 vote199 views1 answer
Flush user resource mysql
SQL
0 vote212 views1 answer
Error: SAP DBTech JDBC: [258]: insufficient privilege: Detailed info for this error can be found with guid '87813FAA56439F48BD60812F3EBEC5A4'
SQL
18 votes193 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
5 votes197 views3 answers
String concatenation sql server
SQL
0 vote202 views3 answers
Remove folders from remote git
SQL