XML

External Article

Examples of using XQuery to update XML Data in SQL Server

  • Article

What is the most efficient way to modify XML values? To allow for precise modification of XML nodes and values, the XQuery XML query language employs an extension known as the XML Data Modification Language (DML). The XML DML uses the XML modify() method, which makes use of three operational keyword sets: insert, replace value of, and delete. Seth Delconte takes a closer look.

2018-07-11

2,712 reads

External Article

Free ebook: Stairway to SQL Server XML

  • Article

Free download to all Simple Talk users. XML has been part of the SQL Standard since 2003, and is essential for any DBA because so many of the dynamic management views return XML data. Now that the industry is more used to data defined by document markup, it is becoming more important than ever for Database Developers and DBAs to understand the technology and to know where it makes sense to use XML.

2017-06-02

6,152 reads

Blogs

New Job -> Week 2 -> Creating a Checklist

By

This is part of a series of new job blog posts. You can find...

SQL Server 2022 Administration Inside Out

By

SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...

WIT/DEI Mental Health and Wellness Day Challenge to Present

By

Back in December 2019, I started presenting my session on mental health with lots...

Read the latest Blogs

Forums

Managed Instance Link and SQL Server 2022

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Managed Instance Link and SQL...

Passing parameters to query without TVFs

By seanachim@hotmail.com

Comments posted to this topic are about the item Passing parameters to query without...

Capturing Data Changes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Capturing Data Changes

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers