-- IPS_DOC_DETAILS.query('data(/IPSDoc/CLIENTINFO/Client/FIRST_NAME)')
declare @x xml = '<x>hello<y>world</y></x><x>again</x>'
select @x.query('data(/*)')
Monday, 16 January 2017
read xml in sql
-- IPS_DOC_DETAILS.query('data(/IPSDoc/CLIENTINFO/Client/FIRST_NAME)')
declare @x xml = '<x>hello<y>world</y></x><x>again</x>'
select @x.query('data(/*)')
Subscribe to:
Posts (Atom)