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 vote114 views1 answer
Denormalise SQL command
SQL
0 vote133 views1 answer
SQL Server Splitting a string column into multiple rows, while repeating ID column
SQL
0 vote99 views1 answer
Sqlite3 not commit
SQL
1 vote110 views1 answer
Sql server reseed single table
SQL
0 vote106 views1 answer
How to select an index in oracle sql
SQL
0 vote113 views2 answers
Find Overlapping sql
SQL
10 votes119 views2 answers
Mysql drop database if exists
SQL
0 vote121 views2 answers
Oracle sql for each row
SQL
9 votes117 views4 answers
Mysql show table fields
SQL
12 votes119 views4 answers
Mysql version
SQL