why used WITH XMLNAMESPACES in tsql ?

Question

why used WITH XMLNAMESPACES in tsql ?

Shadab Shah

SSCarpal Tunnel

Points: 4759
More actions
October 3, 2013 at 1:38 am

#283353

What is the used WITH XMLNAMESPACES in tsql. Does it provide some functionality ? What would break if do not used WITH XMLNAMESPACES.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259125 More actions · Answer 1

Add Namespaces to Queries with WITH XMLNAMESPACES

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Shadab Shah SSCarpal Tunnel Points: 4759 More actions · Answer 2

what is the used of xlmns attribute in XML tag? I tried googling it but to no avail.

Koen Verbeeck SSC Guru Points: 259125 More actions · Answer 3

It defines a namespace.

Use XML Namespaces

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Alan Burstein SSC Guru Points: 61141 More actions · Answer 4

This is a super-simple, but great overview of XML Namespaces

http://www.w3schools.com/xml/xml_namespaces.asp

This article is great for understanding why they exist.

http://msdn.microsoft.com/en-us/magazine/cc302166.aspx

The W3C formal definition (if you ever have problems falling asleep)

http://www.w3.org/TR/REC-xml-names/[/url]

Edit: Make my links clickable :w00t:

"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

-- Itzik Ben-Gan 2001