@@ERROR and/or TRY – CATCH

by

The following article is a must read by Erland Sommarskog, SQL Server MVP: Implementing Error Handling with Stored Procedures

Also note that Your TRY block may fail, and your CATCH block may be bypassed

One more thing: Stored procedures using old-style error handling and savepoints may not work as intended when they are used together with TRY … CATCH blocks.Avoid mixing old and new styles of error handling.

More Related Contents:

  1. T-SQL: Opposite to string concatenation – how to split string into multiple records [duplicate]
  2. Check if table exists in SQL Server
  3. Sql Server string to date conversion
  4. Insert multiple rows WITHOUT repeating the “INSERT INTO …” part of the statement?
  5. Does T-SQL have an aggregate function to concatenate strings? [duplicate]
  6. Parameter Sniffing (or Spoofing) in SQL Server
  7. How to get Time from DateTime format in SQL?
  8. SQL Server String or binary data would be truncated
  9. Datatype for storing ip address in SQL Server
  10. How to change identity column values programmatically?
  11. Cannot truncate table because it is being referenced by a FOREIGN KEY constraint?
  12. How much size “Null” value takes in SQL Server
  13. best way to convert and validate a date string
  14. SQL Server ORDER BY date and nulls last
  15. How to remove accents and all chars a..z in sql-server?
  16. Find non-ASCII characters in varchar columns using SQL Server
  17. WHERE clause on SQL Server “Text” data type
  18. SQL Server error on update command – “A severe error occurred on the current command”
  19. Aggregate bitwise-OR in a subquery
  20. SQL server schema and default schema
  21. Check if a string contains a substring in SQL Server 2005, using a stored procedure
  22. FOR XML PATH(”): Escaping “special” characters
  23. Cannot find either column “dbo” or the user-defined function or aggregate “dbo.Splitfn”, or the name is ambiguous
  24. Does query plan optimizer works well with joined/filtered table-valued functions?
  25. What are row, page and table locks? And when they are acquired?
  26. T-SQL SEQUENCE runs out, no cycle, what happens?
  27. Splitting delimited values in a SQL column into multiple rows
  28. How to check if a database exists in SQL Server?
  29. How to split string and insert values into table in SQL Server
  30. How to query for Xml values and attributes from table in SQL Server?

Leave a Comment