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,460 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,297 reads

Blogs

Information Measurement with SQL Server, Part 4.9: The Bregman Divergence

By

By Steve Bolton …………Before closing out this long-delayed segment on stochastic information distances, I...

Let’s Talk About The Cloud

By

I’m launching a new initiative called the Community Circle Cloud Conversation Club (c5 for...

Daily Coping 29 May 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Daily Coping 29 May 2020

By Steve Jones - SSC Editor

Today’s tip is today link your decisions and choices to your purpose in life....

Week Ending Thursday, can some one tweek my code?

By bark01

What I have missed from this code? I'm trying to show the DateTimeRaised field...

The Matchbox Database

By Phil Factor

Comments posted to this topic are about the item The Matchbox Database

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers