xxxxxxxxxx
/* while loop SQL Server */
DECLARE @Counter INT
SET @Counter = 1
WHILE (@Counter <= 10)
BEGIN
PRINT 'The counter value is = ' + CONVERT(VARCHAR, @Counter)
SET @Counter = @Counter + 1
END
xxxxxxxxxx
WHILE (SELECT AVG(ListPrice) FROM Production.Product) < $300
BEGIN
UPDATE Production.Product
SET ListPrice = ListPrice * 2
SELECT MAX(ListPrice) FROM Production.Product
IF (SELECT MAX(ListPrice) FROM Production.Product) > $500
BREAK
ELSE
CONTINUE
END
PRINT 'Too much for the market to bear';
xxxxxxxxxx
-- SQL server LOOP WHILE
DECLARE @I INT = 0
WHILE @I < 5
BEGIN
SET @I = @I + 1
--+++++++++++++++### START CODE ###+++++++++++++++--
SELECT @I
--+++++++++++++++### END CODE ###+++++++++++++++--
END
xxxxxxxxxx
USE DemoDB
GO
CREATE PROCEDURE dbo.Print100
AS
BEGIN
DECLARE
@Num int= 1
WHILE @Num <= 100
BEGIN
PRINT(@Num)
SET @Num = @Num + 1
END
END