Selecting properties of a content item:
SELECT cast([xml] as xml) as ‘xmldata’, nodeId
FROM dbo.cmsContentXml
WHERE nodeId = ‘1234’ –ID from the node in Umbraco
Selecting properties of a content item:
SELECT cast([xml] as xml) as ‘xmldata’, nodeId
FROM dbo.cmsContentXml
WHERE nodeId = ‘1234’ –ID from the node in Umbraco