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
javilmerAsked:
Who is Participating?
 
ralmadaConnect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.