CREATE PROCEDURE [dbo].[Products_Update]
(
   @productID int,
   @productName nvarchar(40),
   @supplierID int,
   @categoryID int,
   @quantityPerUnit nvarchar(20),
   @unitPrice money,
   @unitsInStock smallint,
   @unitsOnOrder smallint,
   @reorderLevel smallint,
   @discontinued bit
)
AS
BEGIN
  SET NOCOUNT ON;
 
  UPDATE [dbo].[Products]
  SET
  [ProductName] = @productName,
  [SupplierID] = @supplierID,
  [CategoryID] = @categoryID,
  [QuantityPerUnit] = @quantityPerUnit,
  [UnitPrice] = @unitPrice,
  [UnitsInStock] = @unitsInStock,
  [UnitsOnOrder] = @unitsOnOrder,
  [ReorderLevel] = @reorderLevel,
  [Discontinued] = @discontinued
  WHERE [ProductID] = @productID
END