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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Advances In Databases And Information Systems 25th European Conference Adbis 2021 Tartu Estonia August 24 26 2021 Proceedings Lncs 12843
Authors: Ladjel Bellatreche ,Marlon Dumas ,Panagiotis Karras ,Raimundas Matulevicius
1st Edition
3030824713, 978-3030824716
