UFN_CMS_BBPAYTEMPLATE_SITECONTENTDELIVERYPAGE_COUNT

Return

Return Type
int

Parameters

Parameter Parameter Type Mode Description
@SITECONTENTID int IN
@SITEPAGEID int IN
@DELIVERYCHANNELID uniqueidentifier IN

Definition

Copy 


create function dbo.UFN_CMS_BBPAYTEMPLATE_SITECONTENTDELIVERYPAGE_COUNT(
    @SITECONTENTID integer,
    @SITEPAGEID integer,
    @DELIVERYCHANNELID uniqueidentifier = null
)
returns integer
with execute as caller
as begin
    return (
        select count(*) from dbo.CRMBBPAYTEMPLATE 
        where 
            SITECONTENTID > 0 and SITEPAGEID > 0
            and SITECONTENTID = @SITECONTENTID and SITEPAGEID = @SITEPAGEID 
            and coalesce(DELIVERYCHANNELID, '23B56292-0F3C-43AC-AF13-7767AD9D4057') = coalesce(@DELIVERYCHANNELID, '23B56292-0F3C-43AC-AF13-7767AD9D4057'))
end