SQL Server

XML Examples for SQL Server

• Using CDATA in XML
• Handling Namespaces in XML Tags
• Compress XML Content
• Compress XML Tree
• Setting the XML DOCTYPE
• Encrypting and Decrypting Content
• Find Direct Child with Specific Tag
• Methods for Getting Attributes
• GetChild* methods
• Parse the XML of an Excel (XLS) Spreadsheet
• Iterate over Direct Child Nodes by Index
• Iterate over Direct Children with a Specific Tag
• Creating a New Child Node
• Removing / Deleting Child Nodes from XML
• SearchAllForContent
• XML SearchForAttribute Method
• XML SearchForTag Method
• XML Tree Traversal Order for Search* Methods
• XML Sort by Content
• XML Sort by Tag
• XML Sort Records by Content
• Setting XML Tag and Content
• Traverse Direct Children via FirstChild / NextSibling, or LastChild / PreviousSibling
• Update an XML Attribute
• XML GetChildWithAttr
• XML Accumulate Tag Content
• Benefit of XML Methods Having Names Ending in "2"
• Demonstrate the XML FindNextRecord Method
• XML EmitCompact
• XML NewChild2 using a Tag Path
• Demonstrate the XML UpdateAt Method
• Demonstrate the XML UpdateAttrAt Method
• Demonstrate the XML NewChildInt2 Method
• Demonstrate the XML "I" Property
• Demonstrate the XML I, J, and K Properties
• Create XML using Tag Paths
• UpdateChildContent using a Tag Path
• SOAP WS-Security UsernameToken
• SOAP WS-Security Username Authentication
• Access an Inner Node of an XML Document
• Get XML Attribute Value by Path
• Extract and Save PDF from SOAP XML
• Auto-Trim XML Content when Loading
• Create XML with Multiple Same-Tag Children
• Load ucs2 XML File (utf-16)
• Remove an XML Subtree
• Parsing XML Children Having Identical Tags
• Insert PDF as Base64 into XML, then Extract back to PDF File
• Insert after Node with Tag
• XML Path Performance Optimizations
• Extract PDF Invoice from FatturaElettronica XML
• Scrub Xml
• Xml TagPath Property Explained
• Traverse the XML Tree
• Efficiently Process a Huge XML File
• XML Document References
• Insert XML into existing XML by calling InsertChildTreeAfter
• Find XML Element where Attribute = Value
• Find and Update an XML Attribute Value