"ProductCategoryList" Stored Procedure

Description:

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 ASC
        
Database 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.