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 vote156 views1 answer
Sql out file formate
SQL
15 votes144 views6 answers
Psql
SQL
2 votes126 views1 answer
Oracle create directory
SQL
0 vote148 views2 answers
Plsql function that return a table
SQL
0 vote141 views1 answer
Conda install pymysql "windows"
SQL
0 vote135 views1 answer
Shrink database file in sql server
SQL
0 vote173 views2 answers
CREATE OR REPLACE FUNCTION
SQL
8 votes127 views1 answer
Oracle add month
SQL
0 vote122 views2 answers
Influxdb delete measurement based on date
SQL
21 votes158 views4 answers
Add column mssql
SQL