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

7 votes207 views2 answers
Sql empty table
SQL
3 votes188 views1 answer
Pl sql check if variable is empty
SQL
0 vote180 views1 answer
Get only first row mysql
SQL
0 vote204 views1 answer
Sql server insert inner join
SQL
0 vote185 views1 answer
How to get n result in sql
SQL
2 votes199 views3 answers
Replace null in sql
SQL
1 vote197 views2 answers
Create a unqie constraint mysql
SQL
1 vote259 views1 answer
Hangfire clear all jobs
SQL
0 vote206 views1 answer
Sql select lowest value row
SQL
0 vote213 views1 answer
Mysql db dump restore max file size issue
SQL