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 vote151 views2 answers
Php convert dbf to mysql
SQL
0 vote126 views1 answer
Convert rows to columns in sql server
SQL
0 vote155 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
0 vote140 views1 answer
How to generate ids in sql
SQL
0 vote142 views1 answer
Sql select all records from all tables where not empty
SQL
1 vote134 views1 answer
Oracle list datafiles in tablespace
SQL
0 vote135 views1 answer
Mysql a from on this page has
SQL
2 votes137 views1 answer
Copy all values of a column to another column in sql in same table
SQL
0 vote140 views1 answer
Sql list dates between two dates
SQL
0 vote136 views2 answers
Disallowed function mysql to_date()
SQL