Question 4 Not yet answered Marked out of 5.00 The code below contains errors. Can you please correct the errors so that the procedure can execute successfully ALTER PROCEDURE dbo.AddSale @employeeid INT, @productid INT, @quantity SMALLINT. Flag question @saleid UNIQUEIDENTIFIER OUTPUT AS SET @saleiid = NEWIDO BEGIN TRY TRANSACTION BEGIN UPDATE INTO Sales Sales SELECT @saleid, @productid, @employeeid, @quantity TRANSACTION COMMIT END TRY BEGIN CATCH UPDATE INTO dbo.DB_Errors VALUES (SUSER_SNAMEO, ERROR_NUMBER(), ERROR_STATE). ERROR_SEVERITY{}, ERROR_LINE ERROR_PROCEDURE(), ERROR_MESSAGE, GETDATE(); IF (OXACT_STATE()) = -1 TRANSACTION ROLLBACK IF (OXACT_STATE()) = 1 TRANSACTION END CATCH GO