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

6 votes193 views1 answer
Oracle pl sql source
SQL
0 vote182 views1 answer
Sql compound operators
SQL
0 vote181 views1 answer
Postgresql newline character
SQL
0 vote192 views1 answer
Alasql delete column
SQL
2 votes196 views2 answers
Mysql limit
SQL
-1 vote197 views2 answers
First letter capital in mysql query
SQL
1 vote201 views1 answer
Sql exclude duplicates and find even id
SQL
1 vote249 views1 answer
Mysql current running queries
SQL
1 vote224 views3 answers
How to create a table structure from another table in mysql
SQL
0 vote202 views1 answer
Tinydb add table
SQL