Home Forums SQL Server 2005 Development How to get the inner XML from an xml element using XQuery RE: How to get the inner XML from an xml element using XQuery
Brian Chan-449916
SSC Journeyman
Points: 81
More actions
February 26, 2013 at 10:31 am
#1591264
Try:
select @xml.query('(//Author)[1]/*')