Pastebin
API
tools
faq
paste
Login
Sign up
SHARE
TWEET
How to delete all comments from XML using XQuery on SQL Server 2005
code_junkie
Nov 14th, 2011
130
0
Never
Add comment
Not a member of Pastebin yet?
Sign Up
, it unlocks many cool features!
text
0.17 KB
| None
|
0
0
raw
download
clone
embed
print
report
select @XML.query('comment()')
set @XML.modify('delete comment()')
select @XML
UPDATE Store SET Demographics.modify('delete //newnode') WHERE CustomerID = @custid
Add Comment
Please,
Sign In
to add comment
Public Pastes
🤑G2A.com Free Gift Card Guide June 2024 Fix🎁
JavaScript | 2 min ago | 0.31 KB
Fruit?
JSON | 4 min ago | 0.47 KB
🤑G2A.com Free Gift Card Guide June 2024 Fix🤑
JavaScript | 9 min ago | 0.32 KB
🤑G2A.com Free Gift Card Guide June 2024 Fix🎁
JavaScript | 15 min ago | 0.33 KB
🤑 G2A.com Free Gift Card Guide Jun 2024 FIX 🎁
GetText | 16 min ago | 0.36 KB
🤑G2A.com Free Gift Card Guide June 2024 Fix🎁
JavaScript | 21 min ago | 0.32 KB
🤑G2A.com Free Gift Card Guide June 2024 Fix🤑
JavaScript | 27 min ago | 0.33 KB
🤑G2A.com Free Gift Card Guide June 2024 Fix🤑
JavaScript | 33 min ago | 0.33 KB
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the
Cookies Policy
.
OK, I Understand
Not a member of Pastebin yet?
Sign Up
, it unlocks many cool features!