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 @saleid = NEWID

TRY

INSERT Sales.Sales

@saleid,

@productid,

@employeeid,

@quantity

TRY

CATCH

INSERT INTO dbo.DB_Errors

(SUSER_SNAME(),

ERROR_NUMBER(),

ERROR_STATE(),

ERROR_SEVERITY(),

ERROR_LINE(),

ERROR_PROCEDURE(),

ERROR_MESSAGE(),

GETDATE());

CATCH

GO