error catching with current versions of sqlserver is very weak. once a sql
*fatal* error (syntax error and conversion error are examples of these fatal
errors) occurs the entire batch is terminated.
here is some doc on how to catch an error in sqlserver.
RAC v2.2 & QALite!
"anson" <aeze616cse.unsw.edu.au> wrote in message
> Dear sir,
> I have a problem with date conversions. I want to catch an error
> like this in a stored procedure using something like RAISERROR but I'm
> not sure what to do.
> For example, ...