Solved

SQL SERVER  : NULL IN XML ??

Posted on 2010-09-02
5
210 Views
Last Modified: 2012-05-10
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
Comment
Question by:javilmer
5 Comments
 
LVL 41

Accepted Solution

by:
ralmada earned 250 total points
ID: 33589218
have you tried using the XSINIL option?
http://msdn.microsoft.com/en-us/library/bb510413.aspx 
0
 
LVL 16

Assisted Solution

by:vdr1620
vdr1620 earned 250 total points
ID: 33589239
0
 

Expert Comment

by:Modalot
ID: 35292472
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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

680 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question