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(/*)')
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment