Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

why used WITH XMLNAMESPACES in tsql ? Expand / Collapse
Author
Message
Posted Thursday, October 3, 2013 1:38 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 7:26 AM
Points: 268, Visits: 668
What is the used WITH XMLNAMESPACES in tsql. Does it provide some functionality ? What would break if do not used WITH XMLNAMESPACES.
Post #1501030
Posted Thursday, October 3, 2013 1:40 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:15 AM
Points: 13,017, Visits: 10,800
Add Namespaces to Queries with WITH XMLNAMESPACES



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1501031
Posted Thursday, October 3, 2013 2:55 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 7:26 AM
Points: 268, Visits: 668
what is the used of xlmns attribute in XML tag? I tried googling it but to no avail.
Post #1501062
Posted Thursday, October 3, 2013 3:28 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:15 AM
Points: 13,017, Visits: 10,800
It defines a namespace.

Use XML Namespaces




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1501076
Posted Tuesday, October 8, 2013 10:41 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 3:49 PM
Points: 589, Visits: 2,750
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/


Edit: Make my links clickable



-- Alan Burstein



Read this article for best practices on asking questions.
Need to split a string? Try this (Jeff Moden)
Need a pattern-based string spitter? Try this (Dwain Camps)
My blog
Post #1502714
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse