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

44 votes231 views6 answers
Rename command in sql
SQL
0 vote157 views1 answer
Get a list of tables and the primary key
SQL
6 votes140 views1 answer
Rank function in oracle with example
SQL
0 vote276 views1 answer
Android sqlite add column if not exists
SQL
1 vote161 views1 answer
ORACLE RIGHT TWO DIGITS
SQL
17 votes200 views6 answers
Get last record in sql
SQL
-1 vote162 views2 answers
Import data from excel to sql server automatically
SQL
0 vote108 views1 answer
Mysql date + 1 day
SQL
4 votes297 views2 answers
Sql display today's date
SQL
0 vote181 views1 answer
Sql get table last modified time
SQL