You use Microsoft Azure SQL Database to develop a database application. You create a stored procedure named dbo.InsertData. dbo.InsertData uses multiple batch statements to calculate a column named RateofChange and insert data one row at a time.
You need to ensure that when the transaction fails, dbo.InsertData meets the following requirements:
If one row in the batch has a duplicate key error, all other rows will be inserted.
If the value of the RateofChange throws an error, the row will not be inserted.
Which set of Transact-SQL statements should you add to dbo.InsertData?
A.
B.
C.
D.
