USP_SEARCHLIST_BBNCPAGE

Search for all Blackbaud Internet Solutions site pages

Parameters

Parameter	Parameter Type	Mode	Description
@NAME	nvarchar(100)	IN	Name
@MAXROWS	smallint	IN	Input parameter indicating the maximum number of rows to return.

Definition

Copy



CREATE procedure dbo.USP_SEARCHLIST_BBNCPAGE
(
    @NAME nvarchar(100) = null,
    @MAXROWS smallint = 500
)
as

select top(@MAXROWS)
    ID,
    PAGENAME as NAME
from 
    dbo.SITEPAGES
where 
    DELETED = 0
    and ISTEMPLATEPAGE = 0
    and (@NAME is null or (PAGENAME like '%' + @NAME + '%'))
    and ClientSitesID = 1
order by 
    PAGENAME asc