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 vote226 views1 answer
EnvironmentError: mysql_config not found
SQL
13 votes244 views2 answers
Sqlite rename table
SQL
0 vote255 views2 answers
How to install psql in ubuntu
SQL
0 vote243 views1 answer
Insert or update sql firebird
SQL
10 votes243 views2 answers
SQL rounding numbers
SQL
1 vote245 views3 answers
Rows, INSERT INTO
SQL
3 votes227 views3 answers
Concatenation in sql
SQL
-1 vote247 views1 answer
Add 10 to all numbers in a column sql
SQL
0 vote234 views1 answer
Update and keep original value sql
SQL
0 vote244 views1 answer
Sql gather statistics to increase performance
SQL