Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
OPENXML and whitespace
Message
De
04/02/2002 10:05:26
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Import/Export
Titre:
OPENXML and whitespace
Divers
Thread ID:
00614801
Message ID:
00614801
Vues:
102
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
Fil
Voir

Click here to load this message in the networking platform