Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The code below contains errors. Can you please correct the errors so that the procedure can execute successfully. CREATE PRO usp_delete_person( @person_id ) AS BEGIN
The code below contains errors. Can you please correct the errors so that the procedure can execute successfully.
CREATE PRO usp_delete_person(
@person_id
) AS
BEGIN
BEGIN TRY
BEGIN TRANSACTION;
DELETE FROM sales.persons
WHERE person_iid = @person_id;
COMMIT TRANSACTION;
END TRY
BEGIN CATCH
usp_report_error;
IF (XACT_STATE) = -1
BEGIN
PRINT N'The transaction is in an uncommittable state.' +
'Rolling back transaction.'
ROLBACK TRANSACTION;
END;
IF (XACT_STATE) = 1
BEGIN
PRINT N'The transaction is committable.' +
'Committing transaction.'
COMIT TRANSACTION;
END;
END CATCH
END;
GO
can i please get this in under 20mins!!please
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