Stored Procedure error

Question

I am testing something. I want to write a statement in my stored procedure that raises an exception/error. I do not want the dividebyzero exception. Any other statement that raises an exception will work. Any help?

Answer 1

You can use the RAISERROR statement for that purpose.