Rob Sheldon

Stairway to XML

Stairway to XML: Level 8 - Deleting Data from an XML Instance

in order to use the modify() method to delete data from typed and untyped XML instances, you must pass an XML DML expression as an argument to the method. That expression must include the delete keyword, along with an XQuery expression that defines the XML component to be deleted. Robert makes it seem simple, as usual.

2012-11-05

2,485 reads

Stairway to XML

Stairway to XML: Level 3 - Working with Typed XML

You can enforce the validation of an XML data type, variable or column by associating it with an XML Schema Collection. SQL Server validates a typed XML value against the rules defined in the schema collection so that INSERT or UPDATE operations will succeed only if the value being inserted or updated is valid as per the rules defined in the Schema Collection.

2012-10-01

13,370 reads

Blogs

What you need to know About Azure SQL backup

By

Most of DBA are coming from On-premise Database Servers they know very well How...

Social: Respecting Names

By

This is a non-technical post, and my opinion. If you don’t want to read...

Proud to present at this year’s VMworld 2020 conference

By

I’m thrilled to support and participate in this year’s VMworld 2020 conference, which is...

Read the latest Blogs

Forums

Offline Filegroups

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Offline Filegroups

A Data Attack

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Data Attack

Protect SQL Databases with Dell EMC PowerProtect and DataDomain Under VMware

By Shree Das

Comments posted to this topic are about the item Protect SQL Databases with Dell...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers