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