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

Daily Coping 29 Nov 2022

By

Today’s coping tip is to make a meal using a recipe or ingredient you’ve...

My adventures with speaking and what changed

By

I am writing this blog post as contribution to #NewStarNovember and what got me...

Automatically Take Missed Backups with Ola Hallengren’s Scripts

By

I blogged a few years ago about my configuration tables for Ola Hallengren’s maintenance...

Read the latest Blogs

Forums

Basic Checks on a New AWS RDS SQL Server

By Br. Kenneth Igiri

Comments posted to this topic are about the item Basic Checks on a New...

Assigning a Server Role

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Assigning a Server Role

Cloud First Software

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Cloud First Software

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers