In this post, we will discuss how to use while loop in SQL server 2008.
New to Office 365 SharePoint Online? Get Office 365 Enterprise E3 Subscription & Try out all the features
Also, you can check out my previous posts on
Below is the syntax to use While Loop in SQL Server:
DECLARE @flag INT
SET @flag = 0
WHILE @flag <= 5
SET @flag = @flag + 1
PRINT ‘You are in ‘ + CAST (@flag AS NVARCHAR(10)) +’ Loop’
The out put will come as shown in the figure below.
FREE SHAREPOINT 2019 PDF
(Installation & Features)