"GetLinks" Stored Procedure

Description:

This stored procedure returns all of the links for a specific Links module within the portal. The input parameter is the ModuleID. Only announcements whose expiration date is later than today are shown.

Definition:
    
    CREATE PROCEDURE GetLinks
    (
        @ModuleID int
    )
    AS

    SELECT
        ItemID,
        CreatedByUser,
        CreatedDate,
        Title,
        Url,
        ViewOrder,
        Description

    FROM
        Links

    WHERE
        ModuleID = @ModuleID

    ORDER BY
        ViewOrder
        
Database Tables Used:

Links:  Each record in the Links table is a hyperlink, as displayed by the Links Portal Module. Since all Links modules store their record in this table, each item contains a ModuleID to permit related items to be retrieved in a single query.

The primary key in this table is the ItemID identity field. Note that the link description is limited to 2000 characters.