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

0 vote300 views1 answer
Sql not exists
SQL
0 vote318 views1 answer
Mysql page segment
SQL
0 vote277 views1 answer
Postgres get running query
SQL
1 vote289 views2 answers
Difference between in and between in sql
SQL
5 votes307 views1 answer
Postgres integer to serial
SQL
0 vote315 views1 answer
Sql mod even odd
SQL
0 vote293 views1 answer
How to increase the width of the screen in oracle
SQL
1 vote317 views1 answer
Quit mysql
SQL
0 vote280 views1 answer
Store query result in variable sql
SQL
1 vote309 views1 answer
Mysql view current queries
SQL