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 vote132 views1 answer
Sqlalchemy get schema from database
SQL
0 vote118 views2 answers
SQLSTATE[HY000] [2054] The server requested authenticatio n method unknown to the client (SQL: select * from information_schema.tables where table_schema = todos_app and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote111 views1 answer
Selecting Data in SQL - Select Data
SQL
0 vote141 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
2 votes116 views1 answer
Sqlite3 show columns name
SQL
0 vote167 views1 answer
Regex mongoose
SQL
3 votes119 views1 answer
Oracle apex warning message
SQL
2 votes125 views1 answer
Sqlite insert if not exists
SQL
1 vote116 views1 answer
Mysql history command
SQL
0 vote124 views1 answer
Dataframe lambda elif
SQL