This is a simple stored procedure that returns a list of all the product categories in the system. It is the engine behind the _Menu.aspx that builds the navigation menu on the left hand side of the IBuySpy application.
Definition:CREATE Procedure ProductCategoryList AS SELECT CategoryID, CategoryName FROM Categories ORDER BY CategoryName ASCDatabase Tables Used:
Categories: The Categories table contains a list of all the categories used in the system. It drives the menu on the left hand side of the web site. There is a one to many relationship between the Categories table and the Products Table, since every product must belong to a category.