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

16 votes378 views1 answer
Sql comment'
SQL
2 votes317 views1 answer
Sql select in list
SQL
2 votes390 views1 answer
Java.lang.arrayindexoutofboundsexception: index 0 out of bounds for length 0
SQL
2 votes400 views2 answers
Sqlalchemy return id after insert
SQL
0 vote349 views1 answer
How to put is null in where in clause
SQL
0 vote351 views1 answer
How to combine rows in sql server procedure
SQL
0 vote363 views1 answer
Regex mongoose
SQL
0 vote456 views1 answer
Play framework connection via windows sql server
SQL
0 vote394 views1 answer
Sql remove non numeric characters
SQL
0 vote357 views1 answer
Turnicate in mysql
SQL