Msg 133, Level 15, State 1, Line 10
A GOTO statement references the label ‘%.*ls’ but the label has not been declared.
This error message appears when you try to reference a label which has not been declared yet
The SQL statement cannot be parsed and further execution is stopped.
Error of the Severity level 15 are generated by the user and can be fixed by the SQL Server user. All labels that are referenced must also be created.
All versions of SQL Server.
DECLARE @i int;
SET @i = 1;
WHILE @i < 10
SET @i = @i + 1
IF @i = 4 GOTO Branch_2
SELECT ‘This is Branch_1.’
In the above example we try to jump at a certain condition to the non-existant label Branch_1. This raises the error.