Answers for "generate row in sql"

SQL
0

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
Posted by: Guest on June-27-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language