Geek Answers Handbook

Try Catch in SQL Server 2000?

Is it possible to use try-catch in SQL Server 2000?

+5
source share
5 answers

No, It is Immpossible.

It was only from Sql Server 2005

Check TRY ... CATCH (Transact-SQL) and check other versions

+9
source

No. The block Try Catchwas introduced at SQL SERVER 2005.

The following article shows how you can use @@ERRORto check for errors.

Understanding Error Handling in SQL Server 2000

+6
source

@@Error <. >

+4

@@ERRORis a variable updated by the SQL Server database engine after each statement on the server is executed. We can see by Print@@ERROR

+1
source

No Try Catch. 2005 and later introduced, you need to use @@ Error to handle your exception

-1
source

More articles:


All Articles