i have a lot of update statmement in a stored procedure, how can i skip the update statement when there is an error and go to execute update statement???
also when i run the stored procedure, if there is an error that can't be updated, how can i write to log file return error msg to tell you which table which column has an error??
-_-
Member
375 Points
1033 Posts
stored procedure
Feb 24, 2012 07:48 AM|LINK
i have a lot of update statmement in a stored procedure, how can i skip the update statement when there is an error and go to execute update statement???
also when i run the stored procedure, if there is an error that can't be updated, how can i write to log file return error msg to tell you which table which column has an error??