• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 231
  • Last Modified:

SQL SERVER : NULL IN XML ??

Hello,

We have an XML flux in which we need to have NULL values like :
<nodes><node>33</node><node>66</node><node>NULL</node>
how can we specify it ? (the way I did it, it takes NULL as a string)
Thanks for help
0
javilmer
Asked:
javilmer
2 Solutions
 
ralmadaCommented:
have you tried using the XSINIL option?
http://msdn.microsoft.com/en-us/library/bb510413.aspx 
0
 
ModalotEE ModeratorCommented:
Following an Objection by ralmada, and after Moderator review, there seems to be a better  disposition. Because the asker did not return, it is now up to me to distribute points.

Modalot
Community Support Moderator
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now