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

10 votes114 views4 answers
Else if mysql
SQL
0 vote100 views1 answer
Order by ip address sql
SQL
0 vote106 views1 answer
How to tell if i have lactose intolerance
SQL
0 vote101 views1 answer
Sql declare variable single line
SQL
4 votes107 views1 answer
Oracle show errors
SQL
-1 vote99 views1 answer
Select first rows postgresql
SQL
0 vote99 views1 answer
Mysql Install Ubuntu with native password
SQL
4 votes101 views1 answer
Mysql timestamp in laravel migration
SQL
0 vote116 views1 answer
Allow null in psql
SQL
0 vote109 views1 answer
Manage Database in MySQL
SQL