GOTO command in SQL Server

November 2022 · 2 minute read

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 article 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.

    • For example

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

    In the example using this GOTO statement, we created a label named quantrimang, when the @NUMBER variable reached value 5, the program allowed to jump to the position of the quantrimang label in the function and execute the statement following it. .

    See more:

  • 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

    ncG1vNJzZmismaXArq3KnmWcp51ktLDAzmaaqKWdlrulecinZKypnGLApr7Vnqk%3D