forum

Home / DeveloperSection / Forums / Problem using loop in sqlserver

Ask Question

Problem using loop in sqlserver

Somesh240919-Jan-2012
Hi

How to use loop in sqlserver?

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

Somesh

Follow

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

Liked By