Dear Professional...
Can you plz tell me one thing like I have one XML file which is already
saved in C:\File1.xml path.
I want to parse that File1.xml file and save it into database through any
stored procedure or any command but the problem is that how can I call the
file File1.xml from the hard disk and parse it and save it into customer
table. I would highly appreciate if any one guide me this.
Thanks
NOOR
You may want to check out www.sqlxml.org
It has several short tips and guidelines on using the xml features with SQL
Server 2000. In your case, OPENXML function would be appropriate, the
details & examples of which can be found in SQL Server Books Online.
Anith
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment