1.

Write a SQL query to print 1 to 100 in sql server?

Answer» WRITE a SQL query to PRINT 1 to 100 in sql server?
There are 2 methods to do that ONE is with while loop and ANOTHER one is with with statement
(1)Method1
;WITH CTE
AS
(
SELECT 1 [Sequence]
UNION ALL
SELECT [Sequence] + 1 FROM CTE WHERE [Sequence] <100
)
SELECT * FROM CTE

(2)Method2 By Using Loop
declare a INT
set a=0;
While(a<100)
begin
select a=a+1
print a
end


Discussion

No Comment Found

Related InterviewSolutions