Msg 135, Level 15, State 1, Line 4
Cannot use a BREAK statement outside the scope of a WHILE statement.
Watch this example on YouTube
To Fix it replace
Declare @Num1 int = 10
If @Num1 = 20
BEGIN
BREAK
END
While (ISNULL(@Num1, 0) < 10)
BEGIN
Select GetDate()
END
with
Declare @Num1 int = 10
If @Num1 = 20
BEGIN
RETURN
END
While (ISNULL(@Num1, 0) < 10)
BEGIN
Select GetDate()
END
No comments:
Post a Comment