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
235
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
Free money using older build [1.3]
10 min ago | 0.29 KB
Changelly Exploit
CSS | 22 min ago | 0.29 KB
X Brave Filter
26 min ago | 1.19 KB
✅ I earned $19000 with this method
35 min ago | 0.29 KB
Earn $$ on trading
CSS | 47 min ago | 0.29 KB
S.S.S.S.S.S. - Super Special Sonic Server Sec...
53 min ago | 0.18 KB
Crypto Exchange Profits
59 min ago | 0.29 KB
Untitled
1 day ago | 0.55 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!