SQL Server : Print Numbers from 1 – 100 using row_number

Select top 100 row_number() over (order by (select 1)) from sys.columns

Advertisements