UFN_GETXMLPROPERTYFORSITECOPY
Returns a property from the XML Data for all parts for the specified type and batch.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CopyBatchGuid | uniqueidentifier | IN | |
| @ContentTypesID | int | IN | |
| @Property | nvarchar(400) | IN |
Definition
Copy
CREATE function dbo.UFN_GETXMLPROPERTYFORSITECOPY
(
@CopyBatchGuid uniqueidentifier,
@ContentTypesID int,
@Property nvarchar(400)
)
returns @Results table ([SiteContentID] int, Value nvarchar(max))
as
begin
declare @XMLData table([SiteContentID] int,[data] xml)
insert into @XMLData
select ID, XMLData
from dbo.SiteContent where ContentTypesID = @ContentTypesID and CopyBatchGUID = @CopyBatchGUID
insert into @Results
select
SiteContentID,
data.value('(/XMLHashTable/ItemArray/Item[@Name=sql:variable("@Property")]/Value/text())[1]', 'nvarchar(max)')
from @XMLData
return
end