GOTO Command in SQL Server: Tips and Examples

The GOTO command is a simple jump command, which allows an unconditional jump program from GOTO to a location in the program that has a label (laber) command in the same function. This guide will detail how to use this command in SQL Server.

Syntax

The GOTO statement in SQL Server consists of two parts: Commands and labels. We use the following syntax:

The GOTO command includes the GOTO keyword enclosed with the label name label_name

 GOTO label_name; 

The label section includes the label name label_name and the statement to execute next.

 label_name: {. next execution statement .} 

Note:

• label_name must be unique within the function scope.
• There must be at least one command to execute after declaring the label.

As an example,

 DECLARE @Number INT = 1 ; 
 DECLARE @Total INT = 0 ; 
 
 WHILE @Number < = 10 
 BEGIN 
  IF @NUMBER = 5 
  GOTO tipsmake; 
  ELSE 
  SET @Total = @Total + @Number; 
  SET @Number = @Number + 1 ; 
 END; 
 
 tipsmake 
  PRINT @Total; 
 
 GO 

• IF commands . ELSE in SQL Server.
• WHILE loop in SQL Server.
• BREAK (Control Interrupt) command in SQL Server.

Previous lesson: CONTINUE command in SQL Server