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

Hi Guest

MobileUser

HomePage

Jobs

WalkIn

Articles

:) Latest Topic

AJAX

VB.NET

SQL Query

UDDI

CLASS

JavaScript Questions

SharePoint Interview

SilverLight

WCF

general knowledge

ASP.NET

:) Hot Jobs

:) Latest Articles

Write a SQL query to print 1 to 100 in sql server?
Question Posted on 01 Jan 2021

Home >> DataBase >> SQL Query >> Write a SQL query to print 1 to 100 in sql server?

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