justaphase
asked on
Return SQL alert error message
Hello experts,
How can i simulate or return an error message in transact sql?
I knew how to do this but i forgot.
I need to return an sql error inside a procedure. something like this:
"Msg 207, Level 16, State 3, Line 1
missing value."
How can i simulate or return an error message in transact sql?
I knew how to do this but i forgot.
I need to return an sql error inside a procedure. something like this:
"Msg 207, Level 16, State 3, Line 1
missing value."
use RAISERROR ()
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks for the Grade "B" , I hope you need to Go thru the user terms and conditions