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

1 vote323 views1 answer
Insert column after column mysql
SQL
0 vote312 views1 answer
SQL Error 1040 : Too many connections
SQL
0 vote334 views1 answer
Postgres sequence name
SQL
9 votes312 views3 answers
Sequence postgresql
SQL
6 votes312 views1 answer
Postgresql get year
SQL
3 votes371 views2 answers
Savepoint in sql
SQL
0 vote643 views1 answer
Power bi connect to postgresql
SQL
0 vote338 views1 answer
Express api ith mysql data
SQL
0 vote342 views1 answer
Sql sum if
SQL
4 votes384 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL