"GetDocumentContent" Stored Procedure

This stored procedure returns the Content, ContentType and ContentSize for a document stored in the database. The input parameters is the ItemID for the document.

    CREATE PROCEDURE GetDocumentContent
    (
        @ItemID int
    )
    AS

    SELECT
        Content,
        ContentType,
        ContentSize,
        FileFriendlyName

    FROM
        Documents

    WHERE
        ItemID = @ItemID
        

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.