forum

home / developersection / forums / problem using loop in sqlserver

Ask Question

Problem using loop in sqlserver

Somesh 2599 19-Jan-2012
Hi

How to use loop in sqlserver?

Thanks in advance
mssql server mssql server 
Updated on 09-Apr-2013
Somesh

Other

Message
Can you answer this question?
Answer

2 Answers

Shankar M

Shankar M

09-Apr-2013
Hi Somesh,

There is no for loop statement in SQL Server. We use only while statements for Looping. Lets have
a look at this example.

DECLARE @I INT -- Declaring a Local Variable
SET @I =0      -- Assigning a Default Value to Local Variable
WHILE @I <=5   -- Start of the Loop, Evaluates until @I turns to be less than or equal to  5
 BEGIN
    PRINT 'I value is :' + CAST(@I AS VARCHAR(10)) -- Displaying the Present @I value
    SET @I = @I + 1 -- Incrementing the @I value
END            -- End of Loop 

Thanks,
Shankar
Amit Singh

Amit Singh

19-Jan-2012
Hi somesh,

This is the sample code for using loop in sqlserver

Declare @maxNo int
Declare @i int
set @maxNo=4
set @i=1
print 'Output'
---Use while loop----
while(@i<=@maxNo)
begin                
    print @i
    set @i=@i+1
end   

----Output-------
1
2
3
4
advertising
advertising

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy