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 vote368 views1 answer
Mariadb set vertical output format
SQL
3 votes288 views2 answers
Mysql sum with condition
SQL
1 vote333 views1 answer
Get last week data in mysql
SQL
2 votes378 views2 answers
Mysql bidirectional composite primary key
SQL
1 vote330 views1 answer
Oracle user last connected
SQL
3 votes336 views1 answer
Mssql remove column
SQL
32 votes423 views6 answers
Rename column mysql
SQL
2 votes397 views1 answer
Remove foreign key constraints in postgres
SQL
0 vote358 views1 answer
How to remove quotes from a string in ssis load file
SQL
0 vote369 views1 answer
Hue hive UploadingTextFiletoHive
SQL