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

8 votes212 views3 answers
Connect python to mysql
SQL
8 votes202 views4 answers
Postgresql server restart
SQL
0 vote218 views1 answer
How to get number of months between 2 dates sql server
SQL
1 vote196 views2 answers
Mysql remove first and last character from string
SQL
12 votes194 views4 answers
Install mysql ubuntu 18.04
SQL
4 votes214 views3 answers
Sql find second highest salary employee
SQL
3 votes189 views2 answers
Current year sql
SQL
2 votes194 views2 answers
Convert_tz mysql
SQL
0 vote192 views1 answer
How to display value of variable in mysql
SQL
7 votes203 views1 answer
Oracle pagination query offset
SQL