Solved

SQL SERVER  : NULL IN XML ??

Posted on 2010-09-02
5
206 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

832 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