- 1. T-SQL: Parse an XML value
- / Transact-SQL /
- ... AS XML).query('data(/STAFF/GENDER)') AS VARCHAR(10)) AS Gender FROM [dbo].[XML_EVENTS] -- Returns column GENDER for every record/row (eg. "Male") Or -- Using .value() SELECT CAST(Event_XML ...
- Created on 27 March 2014