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 vote141 views1 answer
What is between operator
SQL
0 vote142 views1 answer
Oracle remove line breaks
SQL
0 vote143 views1 answer
Trigger value from maltiple table to single table mysql
SQL
5 votes165 views2 answers
Mysql where in array
SQL
0 vote134 views1 answer
Oracle create package body
SQL
0 vote143 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
1 vote151 views1 answer
Decalre temp table sql
SQL
1 vote132 views1 answer
Pentaho + pasar de excel a sql
SQL
1 vote167 views1 answer
Count of tables in database mysql
SQL
0 vote98 views1 answer
Deleted table in sql trigger
SQL