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 vote186 views1 answer
Test the postgresql db connection
SQL
0 vote190 views1 answer
Get role postgres
SQL
0 vote230 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
0 vote182 views1 answer
Oracle gather table statistics
SQL
1 vote180 views1 answer
Get rows affected mysql python
SQL
0 vote191 views1 answer
Oracle sql get value from several rows and concatenate strings
SQL
0 vote197 views1 answer
Oracle sql number to varchar2
SQL
0 vote178 views1 answer
Mysql select last 15 minutes
SQL
0 vote186 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
0 vote192 views1 answer
What does leave do in mysql
SQL