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

1 vote354 views1 answer
Where not in array sql
SQL
0 vote375 views1 answer
Insert query return id mysql
SQL
1 vote373 views1 answer
Postgres left join
SQL
2 votes316 views1 answer
Mysql select random id from table
SQL
0 vote337 views1 answer
Sql insert from excel
SQL
2 votes347 views1 answer
Mariadb json select
SQL
0 vote325 views1 answer
Drop column from table if exist on live server mysql
SQL
0 vote327 views1 answer
Restore backupfile discourse
SQL
0 vote333 views1 answer
SQL Server INSERT INTO SELECT By Complete Examples - NAYCode.com
SQL
2 votes330 views1 answer
Oracle drop sequence if exists
SQL