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 vote310 views1 answer
Backup mysql schema only
SQL
13 votes461 views4 answers
Sql joining 3 tables
SQL
2 votes308 views1 answer
Sql find not in list
SQL
-1 vote288 views4 answers
Postgres between dates
SQL
2 votes281 views2 answers
Postgres drop column if exists
SQL
7 votes286 views5 answers
Sql remove spaces
SQL
0 vote288 views2 answers
Homebrew nysql launch
SQL
-2 votes267 views1 answer
Mysql see users and passwords
SQL
0 vote267 views1 answer
Heidisql check how much space a row
SQL
0 vote225 views1 answer
Mysql insert with foreign key
SQL