CREATE PROCEDURE [dbo].[Products_Insert]
(
   @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;
 
  INSERT INTO [dbo].[Products]
  (
    [ProductName],
    [SupplierID],
    [CategoryID],
    [QuantityPerUnit],
    [UnitPrice],
    [UnitsInStock],
    [UnitsOnOrder],
    [ReorderLevel],
    [Discontinued]
  )
  OUTPUT inserted.[ProductID]
  VALUES
  (
    @productName,
    @supplierID,
    @categoryID,
    @quantityPerUnit,
    @unitPrice,
    @unitsInStock,
    @unitsOnOrder,
    @reorderLevel,
    @discontinued
  )
END