UFN_TURBOPARSEDICTIONARYFILECODE_ISUNIQUE

Return

Return Type
bit

Parameters

Parameter Parameter Type Mode Description
@FILECODE int IN

Definition

Copy


            create function dbo.UFN_TURBOPARSEDICTIONARYFILECODE_ISUNIQUE(@FILECODE int
            returns bit
            as 
            begin
                declare @DUPLICATECOUNT int;

                select @DUPLICATECOUNT = count(*)
                from dbo.TURBOPARSEDICTIONARY
        where FILECODE = @FILECODE;

                if (@DUPLICATECOUNT <= 1)
                    return 1;

                return 0;

            end