ALTER PROCEDURE [dbo].[Product_GetID]
@ProductID AS INT,
@CategoryID AS TINYINT,
@Description AS VARCHAR(80),
@FullDescription AS VARCHAR(240),
@Price AS DECIMAL(8, 2),
@MarkupPer AS DECIMAL(8, 2),
@LabourHours AS DECIMAL(8, 2),
@LabourRate AS DECIMAL(8, 2),
@Stock AS INTEGER
AS
BEGIN
INSERT INTO Product (CategoryID, Description, Price)
VALUES (0, '', 0);
GO
UPDATE Product
SET CategoryID = @CategoryID,
Description = @Description,
FullDescription = @FullDescription,
Price = @Price,
MarkupPer = @MarkupPer,