You are building a stored procedure for a SQL Azure database. The procedure will add multiple rows to a table. You need to design the stored procedure to meet the following requirements: - If any of t

You are building a stored procedure for a SQL Azure database. The procedure will add multiple rows to a table. You need to design the stored procedure to meet the following requirements: - If any of the new rows violates a table constraint, then no further additions must be attempted and all changes made by the stored procedure must be discarded. - If any errors occur, a row must be added to an audit table, and the original error must be returned to the caller of the stored procedure. What should you include in the design?