fnPageIDByContentID

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@SiteContentID	int	IN

Definition

Copy



    Create  FUNCTION dbo.fnPageIDByContentID(
    @SiteContentID int
    )
    RETURNS INT
    AS
    BEGIN
        DECLARE @SitePageID int

        SET @SitePageID = 0

        SELECT @SitePageID = SitePagesID FROM PageContent WHERE SiteContentID = @SiteContentID

        RETURN @SitePageID
    END