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 vote173 views1 answer
Selecting duplicates
SQL
24 votes184 views5 answers
Import dump mysql
SQL
4 votes169 views1 answer
Change nls_date_format
SQL
-1 vote209 views4 answers
Postgres between dates
SQL
0 vote197 views1 answer
Delete ids between sql
SQL
2 votes162 views1 answer
Mysql how to store lat,lng
SQL
0 vote162 views1 answer
Sql composite key
SQL
0 vote181 views1 answer
Make parameters nullable in sql server
SQL
0 vote175 views2 answers
Temp Space
SQL
18 votes171 views6 answers
Drop table if exists
SQL