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

0 vote211 views1 answer
Extract sql from query object sqlalchemy
SQL
2 votes199 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
25 votes232 views4 answers
Import mysql dump command line
SQL
0 vote218 views1 answer
Convert sqlalchemy.util._collections to list of string
SQL
1 vote293 views1 answer
Insert column after column mysql
SQL
0 vote146 views1 answer
Oracle sql developer script output limit
SQL
0 vote201 views1 answer
Select place default lat long
SQL
0 vote194 views1 answer
Sql trying to delete database in use
SQL
0 vote279 views1 answer
Drop all data from tables
SQL
0 vote219 views1 answer
SQL Server Splitting a string column into multiple rows, while repeating ID column
SQL