Simple Example of WHILE Loop with BREAK and CONTINUE

USE AdventureWorks;
GO
DECLARE @Flag INT
SET
@Flag =
1
WHILE (@Flag < 10)
BEGIN
BEGIN
PRINT
@Flag
SET @Flag = @Flag + 1
END
IF
(@Flag > 5
)
BREAK
ELSE
CONTINUE
END

 

Comments