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

2 votes194 views3 answers
Postgres json to string
SQL
0 vote179 views1 answer
Suse status MySQL
SQL
0 vote157 views1 answer
How to import sqlite driver class in java using maven
SQL
1 vote242 views2 answers
Coderbyte sql solutions
SQL
8 votes168 views2 answers
Select table column name in sql
SQL
0 vote182 views2 answers
Laravel: customize or extend notifications - database model
SQL
1 vote183 views1 answer
Oracle turn off constraint
SQL
0 vote159 views1 answer
Dasebase_url-postgres for windows
SQL
1 vote180 views1 answer
Mysql show long running queries
SQL
6 votes154 views1 answer
Phpmyadmin reset root password
SQL