UFN_EXPORTDEFINITION_QUERYVIEWSINUSE
Returns a list of query view objects that are used by the export definition.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EXPORTDEFINITIONXML | xml | IN |
Definition
Copy
CREATE function dbo.UFN_EXPORTDEFINITION_QUERYVIEWSINUSE(@EXPORTDEFINITIONXML xml)
returns @T table (OBJECTNAME nvarchar(128))
as
begin
insert into @T (OBJECTNAME) select T.c.value('@ObjectName', 'nvarchar(128)')
from @EXPORTDEFINITIONXML.nodes('ExportDefinitionQueryViewNode/*/n[@ObjectName!='''']') as T(c)
insert into @T (OBJECTNAME) select OBJECTNAME
from dbo.QUERYVIEWCATALOG where ID = @EXPORTDEFINITIONXML.value('ExportDefinitionQueryViewNode[1]/@QueryViewID', 'uniqueidentifier');
return;
end;