Problem using loop in sqlserver

Question

Shankar M · Answer

Hi Somesh,There is no for loop statement in SQL Server. We use only while statements for Looping. Lets havea look at this example.DECLARE @I INT -- Declaring a Local VariableSET @I =0 -- Assigning a Default Value to Local VariableWHILE @I &lt;=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 valueEND -- End of Loop Thanks,Shankar

Amit Singh · Answer

Hi somesh,This is the sample code for using loop in sqlserver----Output-------1234

forum

Problem using loop in sqlserver

Can you answer this question?

2 Answers