This touches on XMLCOL which is some awful way to crawl XML from with MSSQL. As example:
SELECT XMLCOL.query('user/name').value('.','NVARCHAR(20)') as name
This is going to look in the "user" node for the "name" node.
This touches on XMLCOL which is some awful way to crawl XML from with MSSQL. As example:
SELECT XMLCOL.query('user/name').value('.','NVARCHAR(20)') as name
This is going to look in the "user" node for the "name" node.
No comments:
Post a Comment