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 votes242 views1 answer
Postgresql transaction
SQL
1 vote230 views1 answer
Sql trigger before delete
SQL
0 vote236 views1 answer
Mysql multiple group by
SQL
0 vote237 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
16 votes279 views3 answers
T-SQL Add Column
SQL
19 votes251 views6 answers
Mysql if null
SQL
0 vote247 views2 answers
Nested query
SQL
0 vote234 views1 answer
View psql output in horizontal scrolling
SQL
0 vote243 views2 answers
Disadvantages of stored procedures sql
SQL
25 votes251 views3 answers
How to use a database to see tables mysql
SQL