"GetDocuments" 存储过程

描述:

This 存储过程 returns all of the documents for a specific Documents module within the portal. The input parameter is the ModuleID.

定义:

    
    CREATE PROCEDURE GetDocuments
    (
        @ModuleID int
    )
    AS

    SELECT
        ItemID,
        FileFriendlyName,
        FileNameUrl,
        CreatedByUser,
        CreatedDate,
        Category,
        ContentSize
        
    FROM
        Documents

    WHERE
        ModuleID = @ModuleID

使用的数据库中的表:

Documents: Each record in the Documents table is a single item, as displayed by the Documents Portal Module. Since all Documents 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.