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 vote343 views1 answer
Example of sql querry result sepapreted by comma
SQL
0 vote396 views1 answer
Use mysql in java program
SQL
1 vote371 views1 answer
Postgresql define pk sequence next number
SQL
0 vote340 views1 answer
Resolved [java.sql.SQLException: ORA-29977: Unsupported column type for query registration in guaranteed mode ]
SQL
0 vote356 views1 answer
Mysql timediff
SQL
0 vote383 views1 answer
Python mysql show databases
SQL
0 vote357 views2 answers
How to find sql server agent jobs related to a database
SQL
1 vote342 views1 answer
Sql list all procedures
SQL
53 votes670 views6 answers
How to install mysql ubuntu
SQL
1 vote353 views2 answers
Datetrunc hour snowflake
SQL