USP_DATALIST_FAFPAGETITLE
List of PageTitle data
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CONTENTID | int | IN | Content Id |
| @SITEPAGEID | int | IN | Site Page Id |
| @PAGETABID | int | IN | Page Tab Id |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_FAFPAGETITLE
(
@CONTENTID int,
@SITEPAGEID int,
@PAGETABID int = null
)
as
set nocount on;
select PAGETITLE
from dbo.MENUITEMS
where CONTENTID = @CONTENTID
and SITEPAGEID = @SITEPAGEID
and PAGETABID = ISNULL(@PAGETABID,PAGETABID)
and ISACTIVE = 1