Introduction
Here I will explain how to use while loop in SQL
Server stored procedure with example.
Description
In previous articles I explained Find First and last day of current month in SQL, Convert Rows to Columns in SQL, Joins in SQL Server and many articles relating to SQL
Server. Now I will explain how to use while loop in SQL
Server stored procedure with example.
To use while
loop in stored procedure we need to write the query like this
DECLARE @loop INT
SET @loop = 0
WHILE @loop <=
10
BEGIN
SET @loop = @loop + 1
PRINT @loop
END
|
If we run above query we will get output like as shown
below
Output:
 |
In this way we can use while loop in SQL Server.
|
If you enjoyed this post, please support the blog below. It's FREE! Get the latest Asp.net, C#.net, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email. |
|||
Subscribe by RSS
Subscribe by Email
|
|||
1 comments :
how to use in query
DECLARE @fromday varchar(30)
DECLARE @endday varchar(30)
DECLARE @month varchar(30)
DECLARE @endmonth varchar(30)
DECLARE @year varchar(30)
DECLARE @endyear varchar(30)
SET @fromday = '1'
SET @endday = '5'
SET @month = 'December'
SET @endmonth = 'September'
SET @year = '2013'
SET @endyear = '2015'
WHILE (@fromday<=@endday)
BEGIN
declare @chl varchar(30)
set @chl='['+@fromday+'],'
set @fromday=@fromday+1;
PRINT @chl
END
select @chl,Comments from Timesheet
go
Note: Only a member of this blog may post a comment.