XML

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

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

SQLXML Bulk Loader Basics

  • Article

SQLXML isn't exactly new technology, but like the even more venerable BCP, it remains the quickest and most reliable way of heaving large quantities of data into SQL Server databases. SQLXML is very versatile, and once set up is wonderfully reliable ETL system, but isn't trivial to learn. Adam Aspin comes to the rescue with a simple guide.

2015-06-23

4,935 reads

Blogs

Code from Redgate Streamed

By

I presented a session today at Redgate Streamed and did a number of demos....

Daily Coping–2 Apr 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...

Learn SSIS and ADF for Free

By

It’s not from SQLServerCentral, though I hope to do more training across the next...

Read the latest Blogs

Forums

Job failed

By ramyours2003

We migrated jobs from sql 2012 to sql 2019 , one  of the job...

Nike Air Max 270 React ENG Photon Dust Coming Soon

By stevenrowe98

has just dropped a brand new “Digital Pink” colorway of the Blazer Mid as...

Need help with sql query in slitting and putting it in table

By anjaliagarwal5

Hello All, I have the following table Table A ID DocNumber InternalDocnumber date DocType...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers