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 vote532 views1 answer
Sql change a colum to unique
SQL
17 votes353 views6 answers
MySQL ORDER BY
SQL
1 vote391 views1 answer
Find size of all DB's postgres
SQL
3 votes372 views1 answer
Laravel database Using Named Bindings
SQL
0 vote362 views1 answer
Mariadb search columns
SQL
0 vote353 views1 answer
How to access to mysql without root
SQL
1 vote359 views1 answer
Name of today sql
SQL
0 vote355 views1 answer
Oracle dynamic select into
SQL
1 vote362 views1 answer
Group_concat max length mysql
SQL
0 vote389 views1 answer
Mysql where sum > 0
SQL