Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

OpenXML and null values

Status
Not open for further replies.
jcoira

jcoira

Programmer
Sep 26, 2001
51
US
Hi,

Does anyone know how to represent null values in XML so when used in an OPENXML statement for updating a table (with an UPDATE statement) it inserts NULL instead of a blank on the cell ?

Any help would be appreciated.

// jcoira
 
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question
Working Days giving NULL values
Replies
8
Views
657
Cpreston
Cpreston
peac3
  • Locked
  • Question
Gaps and islands
Replies
8
Views
599
Chris Miller
Chris Miller
peac3
  • Locked
  • Question
Derive staus date time by aligning start and end datetime
Replies
7
Views
621
Andrzejek
Andrzejek
bmacbmac
  • Locked
  • Question
Inserting XML data into SQLServer returns only NULL values 1
Replies
3
Views
398
Andrzejek
Andrzejek
grnzbra
  • Locked
  • Question
Adding Text to and XML Field 1
Replies
2
Views
320
grnzbra
grnzbra

Part and Inventory Search

Sponsor

Back
Top