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.
Definition:
CREATE PROCEDURE Portal_GetDocumentContent
(
@ItemID int
)
AS
SELECT
Content,
ContentType,
ContentSize,
FileFriendlyName
FROM Portal_Documents
WHERE
ItemID = @ItemID
Database Tables Used:
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.