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 vote303 views1 answer
Sql pad left 0
SQL
6 votes317 views3 answers
[2021-10-05T13:43:48.961Z] error Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote330 views1 answer
Manage Database in MySQL
SQL
2 votes290 views1 answer
Plsql block
SQL
0 vote278 views1 answer
Como verificar registros duplicados no sql postgresql
SQL
0 vote344 views1 answer
Tsql cte in a transaction
SQL
17 votes299 views2 answers
Mysql date to string
SQL
2 votes284 views2 answers
Mysql date range
SQL
1 vote285 views1 answer
Can not connect to mysql server
SQL
8 votes304 views1 answer
Sql remove leading spaces
SQL