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 vote129 views1 answer
Remove from table where
SQL
0 vote142 views1 answer
Postgresql not in alternative
SQL
0 vote139 views1 answer
Sql server select ignore dupplicates
SQL
0 vote196 views1 answer
Select milliseconds mysql
SQL
0 vote146 views1 answer
Distance calculator from lat long sql query
SQL
0 vote125 views1 answer
Running query in redshift
SQL
0 vote158 views1 answer
SQL joins in python
SQL
0 vote146 views1 answer
Insert into select with group by
SQL
0 vote138 views1 answer
Sql server remove enter from string
SQL
0 vote157 views1 answer
Sqlite3 not commit
SQL