Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Tuesday, March 22, 2016 5:42 AM
Points: 298, Visits: 797
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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Monday, May 23, 2016 6:13 AM
Points: 15,149, Visits: 13,035
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 SQLKover.

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: Tuesday, March 22, 2016 5:42 AM
Points: 298, Visits: 797
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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Monday, May 23, 2016 6:13 AM
Points: 15,149, Visits: 13,035
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 SQLKover.

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


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 1:36 PM
Points: 1,821, Visits: 6,123
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



Best practices for getting help on SQLServerCentral
Need to split a string? Try DelimitedSplit8K or DelimitedSplit8K_LEAD (SQL 2012+)
Need a pattern-based splitter? Try PatternSplitCM
Need to remove of replace those unwanted characters? Try PatExclude8K and PatReplace8K.

"I can't 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. " -- Itzek Ben-Gan 2001
Post #1502714
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse