CREATE PROCEDURE [dbo].[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