Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

GOTO statement [T-SQL]

Use this statement to branch to a labeled statement.

label : GOTO label

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.

None.

None.

• SQL/2003    Persistent Stored Module feature.

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

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