GOTO statement [T-SQL]

Description

Branches to a labeled statement.

Syntax

label:
GOTO label

Examples

Example 1

This 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

Usage

Any statement in a Transact-SQL procedure 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.


Side effects

None

Standards

Permissions

None