Question: Consider the following code, and please explain what the outcome will be: ALTER Procedure [dbo].[DeleteStudentTransaction]@Id INT AS BEGIN TRY BEGIN TRANSACTION DELETE FROM Student WHERE
Consider the following code, and please explain what the outcome will be:
ALTER Procedure [dbo].[DeleteStudentTransaction]@Id INT
AS
BEGIN TRY
BEGIN TRANSACTION
DELETE FROM Student WHERE Id=@Id
RAISERROR('Some Random Error',16,1)
COMMIT
END TRY
BEGIN
CATCH ROLLBACK
END CATCH
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help