A little different this time but came across a problem the other day where I had a block of XML as text in SQL Server and I wanted to shred it using OPENXML. The document contained a default namespace, as per the sample given below:-
<launchparam xmlns=”uk.co.alliance-leicester.mortgages”>
<dipconv>
<callvisitid>2</callvisitid>
<options>trigger=1</options>
</dipconv>
</launchparam>’
I had not particularly noticed that [...]
Filed under: SQL Server | Tagged: SQL Server | Leave a Comment »


