【单选题】
You are creating a stored procedure that will delete data from the Contact table in a SQL Server 2005 database. The stored procedure includes the following Transact-SQL statement to handle any errors that occur.<br /> BEGIN TRY  <br /> BEGIN TRANSACTION  <br /> DELETE FROM Person.Contact<br /> WHERE ContactID = @ContactID<br /> COMMIT TRANSACTION<br /> END TRY  <br /> BEGIN CATCH  <br /> DECLARE @ErrorMessage nvarchar（2000） DECLARE @ErrorSeverity int DECLARE @ErrorState int SELECT @ErrorMessage = ERROR MESSAGE（），@ErrorSeverity=ERROR SEVERITY（），@ErrorState = ERROR STATE（） RAISERROR （@ErrorMessage， @ErrorSeverity， @ErrorState） E
A、Add a COMMIT TRANSACTION command to the CATCH block.
B、Remove the COMMIT TRANSACTION command from the TRY block.
C、Add a ROLLBACK TRANSACTION command to the CATCH block.
D、Add a ROLLBACK TRANSACTION command to the TRY block.
查看正确答案
