Reference Manual
   CHAPTER 9. SQL Statements     

GOTO statement [T-SQL]

Function 

To branch to a labeled statement.

Syntax 

label:
GOTO label

Authorization 

None.

Side effects 

None.

Description 

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.

Standards and compatibility 

• SQL/92     Persistent Stored Module feature.

• Sybase     Adaptive Server Enterprise supports the GOTO statement.

Example 

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

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