UFN_LISTBUILDERINSTANCE_ISUNIQUENAME

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@PAGEID	uniqueidentifier	IN
@TABID	uniqueidentifier	IN
@SECTIONID	uniqueidentifier	IN
@NAME	nvarchar(100)	IN

Definition

Copy



        create function dbo.UFN_LISTBUILDERINSTANCE_ISUNIQUENAME
        (
            @ID uniqueidentifier,
            @PAGEID uniqueidentifier,
            @TABID uniqueidentifier,
            @SECTIONID uniqueidentifier,
            @NAME nvarchar(100)
        )
        returns int
        with execute as caller
        as begin
            if exists(
                select 1 from dbo.LISTBUILDERINSTANCE
                where PAGEID = @PAGEID
                and TABID = @TABID
                and SECTIONID = @SECTIONID
                and NAME = @NAME
                and ID <> @ID
            ) return 0;

            return 1;
        end