UFN_EXPORTDEFINITION_FIELDISINUSEBY
Return
| Return Type |
|---|
| nvarchar(200) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @OBJECTNAME | nvarchar(128) | IN |
Definition
Copy
CREATE function dbo.UFN_EXPORTDEFINITION_FIELDISINUSEBY(@OBJECTNAME nvarchar(128))
returns nvarchar(200)
as
begin
declare @RETURNVALUE nvarchar(200);
select
@RETURNVALUE = [EXPORTDEFINITION].[NAME]
from dbo.[EXPORTDEFINITION]
where exists ((select 1
from EXPORTDEFINITIONXML.nodes('//n[@ObjectName]') as T(c)
where (T.c.value('@ObjectName', 'nvarchar(max)') = isnull(@OBJECTNAME, ''))));
if @RETURNVALUE is null set @RETURNVALUE = '';
return @RETURNVALUE;
end;