Look up "GOTO" in Books Online

Yes it is SQL Server 2000 compatible.

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Michael A. A. Schall" <michaelaaschall@s...>
Subject: [sql_language] Syntax Question - "What is error: in the context of
a return statement?"


: I am reviewing some legacy SQL Server 6.5 code.  In the return portion of
: some of the triggers I am finding:
:
: return
: error:
:     raiserror @errno @errmsg
:     rollback transaction
: end
:
: I am unfamiliar with "error:" and I can not find it any documentation.
:
: What is it?
: Is it SQL Server 2000 compatible?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~