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 vote298 views1 answer
Mysql show foreign keys column
SQL
0 vote331 views2 answers
CREATE OR REPLACE FUNCTION
SQL
0 vote319 views1 answer
Sql server list user permissions
SQL
0 vote338 views3 answers
CONTACT FORM SQL
SQL
0 vote339 views1 answer
Check if string is a number sql
SQL
0 vote316 views1 answer
How to connect postgresql database with java
SQL
123 votes538 views5 answers
Sql where contains
SQL
0 vote321 views1 answer
Mysql type for large numbers with many decimal
SQL
0 vote382 views1 answer
ALV GRID events
SQL
0 vote325 views1 answer
Get schema of table sql
SQL