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 vote247 views1 answer
Mysql get first 2 characters of string
SQL
0 vote212 views1 answer
Sql server udf performance
SQL
0 vote224 views1 answer
Openquery update linked server
SQL
13 votes218 views2 answers
Sql count distinct group by
SQL
11 votes223 views2 answers
Having in sql
SQL
4 votes228 views4 answers
Start mysql
SQL
0 vote271 views2 answers
Insert data into multiple tables mysql
SQL
13 votes220 views1 answer
Sql join 3 tables on id
SQL
0 vote164 views1 answer
Ms sql print more than 1 variable
SQL
0 vote203 views1 answer
Mariadb LOAD DATA INFILE
SQL