Adrian Hills • 1/16/2012

Excluding nodes from XML data before returning from SQL Server

Read Original

This technical article provides a detailed guide on removing specific nodes from XML column values in SQL Server. It demonstrates using the XML data type's modify() method, discusses handling single and multiple rows via scalar UDFs or temporary tables, and considers performance implications versus client-side processing.

0 comments
#xml #Xpath #SQL Server
Excluding nodes from XML data before returning from SQL Server

Comments

No comments yet

Be the first to share your thoughts!

Browser Extension

Get instant access to AllDevBlogs from your browser

Top of the Week

1
The Beautiful Web
Jens Oliver Meiert • 2 votes
2
When your coding agent doesn’t understand your project, you’ll get junk
Benjamin Cane • 1 votes
3
LLM Use in the Python Source Code
Miguel Grinberg • 1 votes
4
Wagon’s algorithm in Python
John D. Cook • 1 votes
5
An example conversation with Claude Code
Dumm Zeuch • 1 votes