USP_GETVANITYURLS_DATALIST
List of VanityURLs data
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CLIENTUSERID | int | IN | Client User Id |
| @PAGEID | int | IN | Page Id |
| @CLIENTSITESID | int | IN | Client Sites Id |
Definition
Copy
CREATE procedure dbo.USP_GETVANITYURLS_DATALIST
(
@CLIENTUSERID int = null,
@PAGEID int = null,
@CLIENTSITESID int = null
)
as
set nocount on;
select ID,
VANITYURL
from dbo.VANITYURL (nolock)
where CLIENTUSERID= @CLIENTUSERID
and PAGEID = @PAGEID
and CLIENTSITESID = @CLIENTSITESID
order by ID desc