USP_DATALIST_NEWSREADER

Returns the NewsReader part properties associated with a particular part, or all of them.

Parameters

Parameter	Parameter Type	Mode	Description
@SiteContentID	int	IN	SiteContentID

Definition

Copy



create procedure dbo.USP_DATALIST_NEWSREADER(
    @SiteContentID int = null
)
as
    set nocount on;

     select 
       guid,
       ID,
           SiteContentID
    from dbo.NewsReaders
    where 
  (@SiteContentID is null)
  or
  (SiteContentID = @SiteContentID)