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,135 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,772 reads

Blogs

The Azure-SSIS IR Startup Time

By

If you want to run SSIS packages in Azure Data Factory, you need the...

What is a container anyway?

By

Recently there was a thread on Twitter which established that a lot of IT...

Comparing Execution Plans

By

When you run a query twice, and get dramatically different run times, your first...

Read the latest Blogs

Forums

Statistics Profile Results

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Statistics Profile Results

passing delimited text from stored procedure to show in flat file

By mcfarlandparkway

i have a sample data where i have header row / detailed / total...

Strange update trigger behavior

By andre-119936

Hi. I create a update trigger on a table to audit data changes... the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers