Remarks

GOTO 可出现在条件控制流语句、语句块或过程中，但它不能跳转到该批以外的标签。 GOTO 分支可跳转到定义在 GOTO 之前或之后的标签。

Permissions

GOTO 语句的权限默认情况下授予任何有效用户。

Examples

以下示例显示如何将 GOTO 用作分支机制。

DECLARE @Counter int;  
SET @Counter = 1;  
WHILE @Counter < 10  
BEGIN   
    SELECT @Counter  
    SET @Counter = @Counter + 1  
    IF @Counter = 4 GOTO Branch_One --Jumps to the first branch.  
    IF @Counter = 5 GOTO Branch_Two  --This will never execute.  
Branch_One:  
    SELECT 'Jumping To Branch One.'  
    GOTO Branch_Three; --This will prevent Branch_Two from executing.  
Branch_Two:  
    SELECT 'Jumping To Branch Two.'  
Branch_Three:  
    SELECT 'Jumping To Branch Three.';  
See Also
              控制流语言 (Transact-SQL)

              BEGIN...END (Transact-SQL)

              BREAK (Transact-SQL)

              CONTINUE (Transact-SQL)

              IF...ELSE (Transact-SQL)

              WAITFOR (Transact-SQL)

              WHILE (Transact-SQL)