USP_SEARCHLIST_CLIENTROLES_SEARCH

Searches through Client Roles for a role

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_CLIENTROLES_SEARCH
(
    @NAME nvarchar(100) = null,
    @MAXROWS smallint = 500
)
as
    set @NAME = COALESCE(@NAME,'') + '%' ;

    select top(@MAXROWS)
        GUID [ID],
        NAME
    from 
        dbo.ClientRoles
    where
        ((@NAME is null) or (NAME LIKE @NAME))
        and ClientRoles.EveryoneRole = 0
        and ClientRoles.Deleted=0
    order by 
        NAME asc