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,196 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

12,917 reads

Blogs

Query Performance Tuning with Filtered Statistics

By

Introduction I recently got a call from our DBA telling me that the CPU...

Performance Tuning Steps Query by looking an execution plan and effectiveness of the index Part 2

By

How to read execution plan to improve poorly... [[ This is a content summary only....

VSCode Tips–Remove the Highlighted Line

By

VSCode was making me crazy as I was writing a script. I like a...

Read the latest Blogs

Forums

Growing and Changing

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Growing and Changing

Azure Stretch Database, Part I: Getting Going

By SQLBlimp

Comments posted to this topic are about the item Azure Stretch Database, Part I:...

Minimalistic SELECT

By Thomas Franz

Comments posted to this topic are about the item Minimalistic SELECT

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers