ALTER PROCEDURE [dbo].[aspx_Products_SelectByPrimaryKey]

(

   @productID int

)

AS

BEGIN

  SET NOCOUNT ON;

 

  SELECT

  [ProductID],

  [ProductName],

  [SupplierID],

  [CategoryID],

  [QuantityPerUnit],

  [UnitPrice],

  [UnitsInStock],

  [UnitsOnOrder],

  [ReorderLevel],

  [Discontinued]

  FROM [dbo].[Products]

 

  WHERE [ProductID] = @productID

END