I have been trying to post this morning and it is not going through, so
sorry
for deciding to start a new post.
I have use the code below and it creates the table and inserts one column,
but the columns seems empty. I do not seem to be able to get the
information
that is in the xml file into sql.
Here is the code:
DECLARE @xml XML;
CREATE TABLE Products(xmlCol XML)
INSERT Products
SELECT CONVERT(XML, BulkColumn, 2)
FROM OPENROWSET (BULK 'C:\database\xmldtd\yahoostore.xml', SINGLE_BLOB) AS
Products
Any suggestions? What do I need to do to insert the information from the
xml file into the sql database table along with the correct column names?
Re: xml in plain text file on heavy load. ... even if the XML file is magically and perfectly ... I want to emphasize that IIS would never be caching that XML file on its own ... Application is NOT synchronizing access to your ASP pages. ... (microsoft.public.inetserver.iis)
Re: TAPI 3.0 call attached data ... The format of the Call Attached Data is XML....XML file with CallAttchedData represents one or multiple data lists ... Root element is CallAttachedData.... version CDATA #FIXED "1.0" ... (microsoft.public.win32.programmer.tapi)
Re: XML parser and writer ... them on a calendar.... Therefore I will need to both easily parse and write new XML files.... why not some database technology?... an advanced user can edit the XML file directly at ... (comp.lang.java.programmer)
Re: Zooming Out: The Larger Issue ...XML file or a binary file (smaller and faster to serialize deserialize, ... On startup of your app you could just check if the xml / binary file exists ...datarow = the container of one or more datacolumns wich in there turn hold ... (microsoft.public.dotnet.languages.vb)
Re: XmlTextReader or XmlDocument or SQLCE ... I wouldn't really call it "unrealistic expectations",... I would love to see a 1 second response time... reading a single node from a 200k XML file on any version of CF running on ... > As to saving XML file after each change, ... (microsoft.public.dotnet.framework.compactframework)
