USP_SEARCHLIST_LOCALE

Used to search for locales.

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_LOCALE
(
    @NAME nvarchar(100) = null,
    @MAXROWS smallint = 500
)
as
    set nocount on;

    set @NAME = dbo.UFN_SEARCHCRITERIA_GETLIKEPARAMETERVALUE(@NAME, 0, null);

    select top(@MAXROWS)
        LOCALE.ID, 
        LOCALE.NAME
    from
        dbo.LOCALE
    where
        (@NAME is null) or (LOCALE.NAME like @NAME)
    order by
        LOCALE.NAME;

    return 0;