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,282 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,114 reads

Blogs

Understanding Azure Geo-Redundant Storage

By

While at PASS Summit 2019, I gave a session on designing Azure Disaster Recovery...

Prompt in ADS

By

Ever since VS Code and Azure Data Studio came out, people have been asking...

When Too Much is Not a Good Thing

By

Explore how to avoid unwanted results that oft occur due to lack of attention...

Read the latest Blogs

Forums

*P/S*https://wranglernationalfinalsrodeonfr.co/live/

By khadduss132

https://wranglernationalfinalsrodeonfr.co https://wranglernationalfinalsrodeonfr.co/live/ https://wranglernationalfinalsrodeonfr.co/2019/ https://wranglernationalfinalsrodeonfr.co/2019-live/ https://wranglernationalfinalsrodeonfr.co/nfr-2019-live/ https://wranglernationalfinalsrodeonfr.co/wrangler-2019-live/ https://wranglernationalfinalsrodeonfr.co/tv-channel-coverage/ https://wranglernationalfinalsrodeonfr.co/reddit/ https://wranglernationalfinalsrodeonfr.co/stream/ https://wranglernationalfinalsrodeonfr.co/wrangler-network-2019-live/ https://wranglernationalfinalsrodeonfr.co/national-finals-rodeo-2019-live/ https://wranglernationalfinalsrodeonfr.co/wrangler-national-finals-rodeo-2019-live/ https://wranglernationalfinalsrodeonfr.co/wrangler-nfr-2019-live/ https://wranglernationalfinalsrodeonfr.co/president-cup-final-2019/...

*P/S*https://nfr--nfr.co/presidents-cup-2019/

By khadduss132

https://nfr--nfr.co https://nfr--nfr.co/live/ https://nfr--nfr.co/2019/ https://nfr--nfr.co/2019-live/ https://nfr--nfr.co/nfr-2019-live/ https://nfr--nfr.co/wrangler-2019-live/ https://nfr--nfr.co/tv-channel-coverage/ https://nfr--nfr.co/reddit/ https://nfr--nfr.co/stream/ https://nfr--nfr.co/wrangler-network-2019-live/ https://nfr--nfr.co/national-finals-rodeo-2019-live/ https://nfr--nfr.co/wrangler-national-finals-rodeo-2019-live/ https://nfr--nfr.co/wrangler-nfr-2019-live/ https://nfr--nfr.co/president-cup-final-2019/...

*P/S*https://wranglernationalfinalsrodeo-live.co/presidents-cup-golf-2019/

By khadduss132

  https://wranglernationalfinalsrodeo-live.co/president-cup-final-2019/ https://wranglernationalfinalsrodeo-live.co/presidents-cup-2019/ https://wranglernationalfinalsrodeo-live.co/presidents-cup-golf-2019/ https://wranglernationalfinalsrodeo-live.co/presidents-cup-tournament-2019/ https://wranglernationalfinalsrodeo-live.co/presidents-cup/ https://wranglernationalfinalsrodeo-live.co/the-presidents-cup-2019/ https://wranglernationalfinalsrodeo-live.co/2019-presidents-cup/ https://wranglernationalfinalsrodeo-live.co/presidents-cup-golf-tournament-2019/ https://wranglernationalfinalsrodeo-live.co/tiger-woods/ https://wranglernationalfinalsrodeo-live.co/tiger-woods-live/ https://wranglernationalfinalsrodeo-live.co/presidents-cup-golf-2019-tv-coverage/ https://wranglernationalfinalsrodeo-live.co/golf-2019-tv-coverage/ https://wranglernationalfinalsrodeo-live.co/international-team-vs-united-state-team/...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers