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 vote117 views1 answer
Mysql workbench indent formatting
SQL
0 vote422 views1 answer
How to connect .sql data set to powerbi
SQL
0 vote122 views2 answers
Sql last updated
SQL
0 vote127 views4 answers
Best data type to represent money in mysql
SQL
1 vote129 views1 answer
Adding a default constraint to an existing column in sql
SQL
0 vote133 views1 answer
Alter table engine mysql
SQL
0 vote124 views1 answer
T-SQL Never ending DELETE
SQL
2 votes125 views1 answer
Set username and password for postgresql database
SQL
0 vote145 views1 answer
Python dictionary to sql update
SQL
2 votes140 views1 answer
Mysql id of inserted row
SQL