April 21, 2003 at 12:00 am
Hello everybody.
I have a question to anyone can help.
A stored procedure updates (or insertrs) a record(so far so good) BUT i did (on purpose) a mistake by setting a varchar value to a smalldatetime field. Of course i receive the error 'Server: Msg 295, Level 16, State 3, Line 1'
'Syntax error converting character string to smalldatetime data type.'
How can i catch those errors ? i 've tried the @@error way but when the error occurs the sp stops running. Is there any other way ?
April 21, 2003 at 9:12 am
Catch it where? In the proc or the calling app?
Andy
April 22, 2003 at 8:12 am
In the proc.
I can handle it from the app but the point is not there.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply