| 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 | | |