Database Programming

HomeMy courses DPG621SGeneral Make Up Test

Question 4

Not yet answered

Marked out of 5.00

Flag question

Question text

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,

@saleid UNIQUEIDENTIFIER OUTPUT

AS

SET @saleiid = NEWID()

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_SNAME(),

ERROR_NUMBER(),

ERROR_STATE(),

ERROR_SEVERITY{},

ERROR_LINE(),

ERROR_PROCEDURE(),

ERROR_MESSAGE(),

GETDATE());

IF (()XACT_STATE()) = -1

TRANSACTION ROLLBACK

IF (()XACT_STATE()) = 1

TRANSACTION

END CATCH

GO