ALTER PROCEDURE [dbo].[aspx_Products_SelectAllByCategoryID]

(

   @categoryID int

)

AS

BEGIN

  SET NOCOUNT ON;

  SELECT

  [ProductID],

  [ProductName],

  [SupplierID],

  [CategoryID],

  [QuantityPerUnit],

  [UnitPrice],

  [UnitsInStock],

  [UnitsOnOrder],

  [ReorderLevel],

  [Discontinued]

  FROM [dbo].[Products]

  WHERE [CategoryID] = @categoryID