Questions Linux Laravel Mysql Ubuntu Git Menu

HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin

Try Catch in SQL Server 2000?

Tags:

sql

sql-server

sql-server-2000

try-catch

Is it possible using Try-Catch in SQL Server 2000?

like image

627

asked Dec 24 '10 06:12

Soner Gönül

2 Answers

No, it is not possible.

This was only from Sql Server 2005

Check TRY...CATCH (Transact-SQL) and check the Other Versions

like image

146

answered Sep 29 '22 20:09

Adriaan Stander

No. Try Catch block was introduced in SQL SERVER 2005.

Following article shows how you can use @@ERROR to check for errors.

Understanding error handling in SQL Server 2000

like image

23

answered Sep 29 '22 20:09

decyclone

Sign in to Comment

Related questions
                            
                                Minimum number of Meeting Rooms required to Accomodate all Meetings in MySQL
                            
                                BigQuery Standard SQL: how to return the first value of array?
                            
                                Does LINQ-to-SQL Support Composable Queries?
                            
                                How do you count the rows in a SQL query which already used count, group by, and having before?
                            
                                Join query or subquery
                            
                                What was your coolest SQL optimization, on a slow performing query?
                            
                                Persistent temp tables in SQL?
                            
                                LINQ and paging with a listview
                            
                                SQL Query for Disabled Active Directory Accounts
                            
                                What is the WITH statement doing in this example? I'm trying to randomly generate data
                            
                                Exclude Statement in SQL
                            
                                SQL Select top frequent records
                            
                                Can .bat file execute an sql query and return a value?
                            
                                MySQL delete row from multiple tables
                            
                                how to select * from tableA where columnA values don't start with letter 'F'
                            
                                Get list of tables but not include system tables (SQL Server 2K)?
                            
                                What is the difference in these two queries as getting two different result set?
                            
                                Mysql: How to get every rows that have more than a certain number of decimal after the dot
                            
                                Mysql DateTime group by 15 mins
                            
                                Easiest way to get a total count and a count of a subset?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!

Donate Us With