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 ViewOrderDatabase 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.