Important Interview Questions in Sql Server.

1.Ho to print 1-100 numbers without using loop?


SOL:
  with cte
  as
  (
  select 1 as count
    union all
 select count + 1 from cte where count <100
 )
select * from cte