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.

Rob Sheldon

2012-11-05

2,092 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.

Rob Sheldon

2012-10-01

12,667 reads

Blogs

CISA Accredited Trainer!

By Brian Kelley

My certification came in! I’m now accredited to provide training for the Certified Information...

Correlated Subqueries vs Derived Tables

By Bert Wagner

Correlated subqueries provide an intuitive syntax for writing queries that return related data. However,...

Video – Creating Azure SQL Database

By Arun Sirpal

A quick 2 minute upload (with sound, my voice) showing you how easy it...

Read the latest Blogs

Forums

Troubleshooting with. wait stats (last 2 weeks included)

By DataAnalyst011

I’m troubleshooting a slow SQL Server. Our server team is adamant it doesn’t need...

grant user read only whole server

By cphite

Hello — I should know this…  but is there any way to grant a...

Query to Find Mismatches

By MalcolmS

New user with what should be an easy question. I have two tables; both...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers