Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion AI Tools Integration
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

forum

home / developersection / forums / problem using loop in sqlserver
Ask Question

Problem using loop in sqlserver

Somesh 2673 19 Jan 2012
Hi
How to use loop in sqlserver?
Thanks in advance
mssql server mssql server
Updated 09 Apr 2013
Somesh
Somesh

Other

Message

2 Answers

Shankar M
Shankar M 09 Apr 2013
Report Abuse
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
Report Abuse
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
MindStick Training