Information générale
Forum:
Microsoft SQL Server
Titre:
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
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement