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
Showing posts with label cte. Show all posts
Showing posts with label cte. Show all posts
Sunday, July 3, 2016
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
Subscribe to:
Posts (Atom)