Now, I need to update several tables to MS-SQL after after users submitting a form. I can write three sql statements to do this, but I'm afraid the user may stop the process in the process or a table got an error.
Besides writing a stored procedure, what other methods can I do this? How about using the batch mode? I'm not sure about this. Thank you!