UFN_EXPORTDEFINITION_FIELDISINUSE

Return

Return Type
bit

Parameters

Parameter Parameter Type Mode Description
@OBJECT nvarchar(255) IN

Definition

Copy


                create function dbo.UFN_EXPORTDEFINITION_FIELDISINUSE(@OBJECT nvarchar(255))
                returns bit
                as 
                begin
                    if exists(select 1 from dbo.EXPORTDEFINITION
                                        where EXPORTDEFINITION.EXPORTDEFINITIONXML.exist('//n[@ObjectName=sql:variable("@OBJECT")]') = 1 )
                    begin
                        return 1;
                    end
                    return 0;
                end