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 vote197 views1 answer
How to run parallel queries in sql server with entity framework
SQL
0 vote187 views1 answer
Object of class sendgrid\mail\mail could not be converted to string
SQL
1 vote258 views3 answers
Date_add mysql
SQL
0 vote335 views1 answer
Mysql delete entire row on condition
SQL
0 vote183 views1 answer
Sql where part of string match
SQL
0 vote137 views1 answer
How do i calculate someone's age based on a datetime type birthday?
SQL
1 vote179 views1 answer
Oracle add proxy
SQL
2 votes168 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
1 vote303 views1 answer
How to select department from table
SQL
-1 vote181 views1 answer
Pl/sql how to delete a trigger
SQL