GOTO statement [T-SQL]

Use this statement to branch to a labeled statement.

Syntax
label : GOTO label
Remarks

Any statement in a Transact-SQL procedure, trigger, or batch can be labeled. The label name is a valid identifier followed by a colon. In the GOTO statement, the colon is not used.

Permissions

None.

Side effects

None.

Standards and compatibility
  • SQL/2003   Persistent Stored Module feature.

Example

The following Transact-SQL batch prints the message "yes" on the database server messages window four times:

DECLARE @count SMALLINT
SELECT @count = 1
restart:
   PRINT 'yes'
   SELECT @count = @count + 1
   WHILE @count <=4
    GOTO restart