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