General information
Forum:
Microsoft SQL Server
Title:
OPENXML and whitespace
How can I force OPENXML to include all leading and trailing whitespace, and newlines that are in my xml data?
All whitespace and newlines are being removed from my xml data when I use OPENXML to import the data into the database. I am using a specific database table to map the data to datatypes in the database, as in:
Select * from OPENXML(....) WITH myTable
I am aware that there is an attribute called 'xml:space' to force whitespace to remain in the data, but since I am using the database table itself to import I don't have a DTD to add this attribute to.
Is there a way to force OPENXML to include all whitespace and newlines that exist in my xml data?
Thanks,
---Tom
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only