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 vote249 views1 answer
FIND ABOVE AVERAGE SALARY EARNER IN SQL
SQL
4 votes258 views2 answers
SELECT table_name FROM user_tables;
SQL
2 votes250 views1 answer
Oracle drop table free up space
SQL
0 vote246 views1 answer
Oracle INTERVAL DAY to second to number
SQL
25 votes271 views5 answers
Date in mysql
SQL
10 votes263 views6 answers
Sql between
SQL
0 vote272 views1 answer
How to convert external table to managed table in hive
SQL
25 votes291 views4 answers
Import mysql dump command line
SQL
27 votes255 views4 answers
Get all tables with column name sql
SQL
1 vote259 views1 answer
Sql server: difference between hashtable and table declared using declare keyword
SQL