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 vote243 views1 answer
SQL-Arten
SQL
1 vote210 views2 answers
Sql multiline comment
SQL
0 vote216 views1 answer
Query params sql insert python f string
SQL
0 vote238 views2 answers
Mysql show foreign keys
SQL
0 vote208 views1 answer
Go install mysql
SQL
0 vote280 views1 answer
Best sql collation
SQL
0 vote217 views1 answer
Create domain sql
SQL
12 votes199 views4 answers
Mysql get date difference in hours
SQL
0 vote231 views1 answer
Character count sql
SQL
0 vote203 views2 answers
Oracle sql for each row
SQL