SQL Server: GOTO Statement
This SQL Server tutorial explains how to use the GOTO statement in SQL Server (Transact-SQL) with syntax and examples.
The GOTO statement causes the code to branch to the label after the GOTO statement.
The syntax for the GOTO statement in SQL Server (Transact-SQL) consists of two parts – the GOTO statement and the Label Declaration:
The GOTO statement consists of the GOTO keyword, followed by a label_name.
The Label Declaration consists of the label_name, followed by at least one statement to execute.
- label_name must be unique within the scope of the code.
- There must be at least one statement to execute after the Label Declaration.
Let’s look at how to use the GOTO statement in SQL Server (Transact-SQL).
DECLARE @site_value INT; SET @site_value = 0; WHILE @site_value <= 10 BEGIN IF @site_value = 2 GOTO TechOnTheNet; SET @site_value = @site_value + 1; END; TechOnTheNet: PRINT 'TechOnTheNet.com'; GO
In this GOTO example, we have created one GOTO statements called TechOnTheNet. If @site_value equals 2, then the code will branch to the label called TechOnTheNet.