Question : I need to conditionally raise an error, but I can only use a simple statement and no stored […]
Tag: raiserror
Distinguish errors I raise from other SQL Server errors
Question : In my stored procedures, when a business rule is broken I raise an error that bubbles up to […]
RAISERROR on a trigger. What will happen? Will we get informed?
Question : What will happen if a trigger on a table hits the part of the trigger that includes the […]
MySql Insert signal if where clause fails
Question : As part of a chained sequence of transactional queries, I’m inserting values that exist in a temporary table […]
How can I RAISE_APPLICATION_ERROR and do an INSERT in the same trigger?
Question : From what I see, having the RAISE_APPLICATION_ERROR cancels the other operations that I would have in the trigger. […]
SSMS / SQL-Server delays console output (RAISEERROR WITH NOWAIT)
Question : It is well known, that SSMS (or maybe the SQL Server, but I’d guess more the SSMS) delays […]
raise an error in sql server severity higher than 18
Question : I can easily raise user defined errors where severity is not higher than 18. When is higher, I […]
Raising an Alert with THROW
Question : It seems to me that SQL THROW is missing a crucial feature that RAISERROR has, and that is […]