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 vote221 views1 answer
Mysql:5.6 syntax create table
SQL
1 vote200 views1 answer
Setval pgsql
SQL
3 votes315 views3 answers
Mysql get table size
SQL
31 votes193 views1 answer
Postgresql add column with constraint
SQL
0 vote211 views1 answer
Creating a simple notify in postgresql
SQL
7 votes204 views4 answers
What is my mysql version
SQL
0 vote215 views1 answer
Alter rename command in mysql
SQL
0 vote201 views1 answer
Pl/ sql change currency
SQL
3 votes192 views1 answer
Start mysql server linux terminal
SQL
2 votes198 views1 answer
Cast string to datetime mysql
SQL