The error-handling tag has no wiki summary.
4
votes
1answer
113 views
how much overhead an error in RDBMS has?
I have a class in my project. On the class I need to do two inner select, to know is there any duplication or not, but I think if I get duplication error and then manage that is better than to select.
...
6
votes
2answers
307 views
Pros and Cons of Checking if value exist for unique column or let db raise unique error on inserting
While writing a query other day a thought came to me and have stuck in my mind.
What is preferable, first checking if a value for a unique column exists and then inserting or insert and let db raise ...
3
votes
1answer
3k views
Equivalent functions in MySQL that exist in SQL Server
In an EXIT HANDLER block, what are the MySQL equivalents of
OBJECT_SCHEMA_NAME(@@PROCID) + '.' + OBJECT_NAME(@@PROCID)
ERROR_MESSAGE()
Edit
What I want to do.
In SQL Server I'd have
CREATE PROC ...
