Gokuldas Palapatta
This blog is all about the issues and frictions which i have faced as a developer ;)
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(/*)')
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)