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 vote308 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL
4 votes333 views1 answer
Ms sql truncate table vs delete
SQL
4 votes316 views5 answers
Get last query in codeigniter 4
SQL
1 vote287 views2 answers
String to date postgres
SQL
0 vote314 views1 answer
Add a new column into table
SQL
2 votes318 views1 answer
Sql server find columns list in tables
SQL
0 vote477 views2 answers
Create new table from existing table with data in sql server
SQL
0 vote290 views1 answer
Sql server bool select
SQL
0 vote282 views2 answers
How to find max and min salary in sql
SQL
7 votes285 views3 answers
Sql get last inserted row
SQL