Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ashish.johri
Starting Member
10 Posts |
 Posted - 2007-08-13 : 04:38:23
|
| Please find the code below (which I am using).1)CREATE TABLE rssFeeds( feedXML XML)SELECT * FROM RSSFEEDSDECLARE @xmlDoc XML SET @xmlDoc = ( SELECT * FROM OPENROWSET ( BULK 'C:\Test.xml', SINGLE_CLOB ) AS xmlData)2)INSERT INTO rssFeeds (feedXML) VALUES (@xmlDoc)I am able to get the contents of xml file into sql server in only one field of Table. Now I am asked to make one table with the schema same as xml file's. How to proceed? Pls let me know some URL for this.Regards,Ashish Johri |
|
|
ashish.johri
Starting Member
10 Posts |
Posted - 2007-08-13 : 06:47:06
|
| Is there any limit on the no of characters or data in xml file that can be exported from xml to MS SQL Server?Regards,Ashish Johri |
 |
|
|
|
|
|
Loading data from xml to Sql Server 2005