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 vote201 views1 answer
How to see all table partition in oracle
SQL
0 vote205 views1 answer
Sql server obtener nombre sin espacios en blanco
SQL
29 votes206 views6 answers
Delete all rows from table mysql
SQL
0 vote209 views1 answer
Postgresql isnull with max
SQL
3 votes256 views4 answers
Postgresql change timezone on timestamp without timezone
SQL
0 vote212 views1 answer
Firebird where
SQL
3 votes203 views1 answer
Mysql set field unique
SQL
0 vote213 views1 answer
Create table in dbms cmds
SQL
0 vote237 views1 answer
Postgresql custom order by
SQL
0 vote203 views1 answer
Get server date mysql
SQL