ALTER PROCEDURE [dbo].[aspx_Products_Insert]

(

   @productName nvarchar(80),

   @supplierID int,

   @categoryID int,

   @quantityPerUnit nvarchar(40),

   @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

  )