goto label

Branches to a user-defined label.

Syntax

label: 
	goto label

Example 1 – Shows the use of a label called restart:

declare @count smallint 
select @count = 1 
restart: 
  print "yes" 
select @count = @count + 1 
while @count <=4 
  goto restart

The label name must conform to the rules for identifiers and must be followed by a colon (:) when it is declared. It is not followed by a colon when it is used with goto.
Make the goto dependent on an if or while test, or some other condition, to avoid an endless loop between goto and the label.

ANSI SQL – Compliance level: Transact-SQL extension.

No permission is required to use goto.