Umbraco SQL query snippets

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