Tsql generate rows

-- generate a identity, and guid table without looping
;with guids( i, guid ) as
(
    select 1 as i, newid()
        union all
    select i + 1, newid()
        from guids
        where i < 10000
)

select i, guid   
from guids 
order by i desc

Similar codes

1 vote120 views1 answer
Increase existing date in sql oracle
SQL
8 votes119 views10 answers
Sql
SQL
0 vote132 views1 answer
Sql basic commands
SQL
0 vote153 views1 answer
Sql alchemy escape ; in insert statement
SQL
1 vote98 views1 answer
Use of now() in mysql
SQL
0 vote115 views1 answer
Datagrip execute procedure
SQL
0 vote101 views1 answer
Min mysql
SQL
12 votes106 views2 answers
Select into insert sql server
SQL
5 votes123 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
1 vote102 views1 answer
Oracle select first result
SQL