USP_DATALIST_GETSITECONTENT

Get SiteContent data

Parameters

Parameter	Parameter Type	Mode	Description
@ContentTypesID	int	IN	Content Types ID
@ClientSitesID	int	IN	Client Sites ID

Definition

Copy



CREATE procedure dbo.USP_DATALIST_GETSITECONTENT
(
    @ContentTypesID integer = null,
    @ClientSitesID integer = null
)
as
    set nocount on;

    SELECT  ID,
            Title,
            XMLData,
            ClientSitesID, 
            ContentTypesID
    FROM dbo.SiteContent
    WHERE ContentTypesID = @ContentTypesID
    AND ClientSitesID = @ClientSitesID