Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Openxml issue
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Miscellaneous
Thread ID:
00813617
Message ID:
00813688
Views:
8
Hi Eric,

Try
select * from openxml (@idoc, '/*/*') WITH (string  char(16) '.')
>Thanks Sergey.. it really doesnt make sense to me why the other way didnt work.. anyway.. another question.. it wount let me have any properties in the root element.. ex
<ArrayOfString xmlns:xsd="http://www.w3.org/2001/XMLSchema" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
xmlns="https://secure.mio.uwosh.edu/webservices/">
>
>Do I have to parse these out before I sent it to the sql server?? Is there some way I can tell the server to ignore it?
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform