Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Is there any way in a stored proced
- Thread starter LokiDba
- Start date
Yes.
Use the @@error object to check for errors after your insert\update code. if @@error <> 0 then an error has occured, you can return a message to the user to tell them the Insert\update has failed.
See SQL server books online for more info on @@error.
Andy
Use the @@error object to check for errors after your insert\update code. if @@error <> 0 then an error has occured, you can return a message to the user to tell them the Insert\update has failed.
See SQL server books online for more info on @@error.
Andy
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question