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 vote319 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL
0 vote175 views2 answers
Sql last updated
SQL
0 vote189 views1 answer
SQLServerException.makeFromDatabaseError
SQL
0 vote223 views2 answers
Find lowest number in sql
SQL
0 vote171 views1 answer
Sqlalchemy.exc.OperationalError:
SQL
0 vote201 views1 answer
Mysql best varchar length size
SQL
4 votes166 views4 answers
Print pl sql
SQL
0 vote166 views3 answers
How to verify sequence result in oracle SQL
SQL
1 vote267 views1 answer
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
SQL
6 votes190 views3 answers
Mysql server is not starting xampp
SQL