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

2 votes266 views1 answer
Oracle number to percentage
SQL
1 vote271 views1 answer
Md5 encryption for existing records
SQL
-1 vote249 views2 answers
How to display top 50 rows?
SQL
0 vote295 views1 answer
Sql constarint
SQL
1 vote249 views1 answer
How to see all table partition in oracle
SQL
0 vote253 views1 answer
Truncate a table then insert data
SQL
0 vote293 views3 answers
How to verify sequence result in oracle SQL
SQL
0 vote260 views1 answer
Join in update query in mysql
SQL
23 votes278 views6 answers
How to create table in sql
SQL
-2 votes292 views2 answers
Add auto_increment column to existing table mysql
SQL