USP_DATALIST_SEARCHPART

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

Parameters

Parameter	Parameter Type	Mode	Description
@SiteContentID	int	IN	SiteContentID

Definition

Copy



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

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