"GetSingleAnnouncement" 存储过程

描述:

This 存储过程 returns a single announcement item from the database. The input parameter is ItemID, the primary key for the record. The return values include the announcement details, as well as information about the users that created and last edited this item.

This 存储过程 is used by the edit page for Announcements.

定义:

    
    CREATE PROCEDURE GetSingleAnnouncement
    (
        @ItemID int
    )
    AS

    SELECT
        CreatedByUser,
        CreatedDate,
        Title,
        MoreLink,
        MobileMoreLink,
        ExpireDate,
        Description

    FROM
        Announcements

    WHERE
        ItemID = @ItemID

使用的数据库中的表:

宣告: Each record in the Announcements table is a single item, as displayed by the Announcements Portal Module. Since all Announcement 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 announcement descriptions are limited to 2000 characters.