INF: Checking Results of Stored Procedures with RAISERROR

ID: Q67933

The information in this article applies to:

Microsoft SQL Server for OS/2, version 4.2

One way to check the results of a stored procedure is to use RAISERROR within the stored procedure to set the global variable @@ERROR. Then, when you return to the first procedure, you can check for the value of @@ERROR.

Another way to check the results of a stored procedure is to determine the number of open transactions by referencing the global variable @@TRANCOUNT.

Keywords : kbprg SSrvStProc
Version : 4.2
Platform : OS/2
Issue type :