Package gudusoft.gsqlparser.stmt.mssql

Class TMssqlTryCatch

Object
gudusoft.gsqlparser.nodes.TParseTreeNode
gudusoft.gsqlparser.TCustomSqlStatement
gudusoft.gsqlparser.stmt.mssql.TMssqlTryCatch
All Implemented Interfaces:
IRelation, Visitable, Iterator<TSourceToken>
public class TMssqlTryCatch extends TCustomSqlStatement
Represents SQL Server TRY...CATCH statement.

Syntax: 

 BEGIN TRY
     { sql_statement | statement_block }
 END TRY
 BEGIN CATCH
     [ { sql_statement | statement_block } ]
 END CATCH

Example: 

 BEGIN TRY
     SELECT 1/0;
 END TRY
 BEGIN CATCH
     SELECT ERROR_MESSAGE();
 END CATCH