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