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 vote145 views1 answer
Search column name sql
SQL
0 vote135 views1 answer
Create date sql
SQL
0 vote163 views1 answer
Sql delimiter to columns
SQL
3 votes147 views1 answer
Pl sql escape &
SQL
1 vote144 views1 answer
What is in condition in sql
SQL
0 vote140 views1 answer
Connecting to my cloud sql server with c#
SQL
0 vote104 views4 answers
Sql limit 1 offset 1
SQL
1 vote157 views2 answers
Postgresql truncate cascade restart identity
SQL
0 vote151 views1 answer
How to remove default in mysql
SQL
0 vote152 views1 answer
Order by with where clause in mysql
SQL