Re: XML file to Database
From: Tom Moreau (tom_at_dont.spam.me.cips.ca)
Date: 02/04/05
- Next message: Ross Presser: "Re: SQL question: How to periodically read the last 'n' rows of a simple table?"
- Previous message: Lou Machado: "WMI methods availabe for SQL Server??"
- In reply to: Emma: "XML file to Database"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 4 Feb 2005 18:13:59 -0500
Is it that you want to store the XML into a single column in a table or do
you want to shred the document? If you want to store the whole thing in a
single document, sue a varchar, nvarchar, text or ntext as appropriate. If
you want to shred it, check out:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpro01/html/sql01c5.asp
-- Tom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA SQL Server MVP Columnist, SQL Server Professional Toronto, ON Canada www.pinnaclepublishing.com . "Emma" <Emma@discussions.microsoft.com> wrote in message news:90762FB5-E462-4AB9-9BD9-FA44E6B4DC19@microsoft.com... I have a database application that stores configuration information in an XML file on the user’s desktop/laptop. If the user’s computer crashes, the configuration information is lost. In addition, the user can’t work on any other computer. When they do, they end up using the configuration on that computer. I want to store this information in the database so that the user can work from any work station and still retrieve their configuration information. How can I read the XML file into a database? I want to write a separate procedure to read all XML file into a database. The columns in the file will be something like this: UserID VARCHAR(30) ConfigurationID VARCHAR(10) ConfigurationData IMAGE Thanks
- Next message: Ross Presser: "Re: SQL question: How to periodically read the last 'n' rows of a simple table?"
- Previous message: Lou Machado: "WMI methods availabe for SQL Server??"
- In reply to: Emma: "XML file to Database"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
