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 votes258 views1 answer
Grant schema permissions postgres
SQL
1 vote219 views1 answer
How to run sql script
SQL
7 votes285 views2 answers
Show size database mysql
SQL
0 vote266 views2 answers
Postgresql create role
SQL
0 vote310 views1 answer
Primary key start from number
SQL
1 vote294 views3 answers
Alter schema sql server
SQL
11 votes292 views2 answers
Mysql set safe mode off
SQL
1 vote254 views2 answers
Procedure pl/sql
SQL
17 votes271 views6 answers
Mysql import sql file
SQL
0 vote249 views1 answer
Postgres get running query
SQL