This post aims to be a quick reference source for the beginners and shows a few simple SELECT examples. Reading attributes from an XML variable DECLARE @x XML SET @x = '<author fname="Michael" lname="Howard" />' SELECT @x.value('(/author/@fname)[1]', 'VARCHAR...
Posted to
Jacob's Blog
by
Jacob Sebastian
on
07-01-2010
Filed under:
Filed under: XQuery-Functions, XQuery-Labs, XML, XQuery, SQLSERVER, BRH, XQuery Tutorials, XQuery Lab, XQuery Functions, xquery-lab, #XML, #XQUERY, #TSQL, SQL Server XQuery, XQuery in TSQL, XQuery Training