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 |
|
vinnakanna58
Starting Member
5 Posts |
 Posted - 2009-07-01 : 01:11:15
|
| Hi All,i created clr stored procedure in that am reading xml file data and putting in to dataset (ds.readxml("xml.xml")).so in this case am facing problem i.e above stament is not executing so any one can give how to read xml file in clr stored procedure .after that am reading dataset and am sending data to perticular table.thanqvinay kumar k |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-07-01 : 12:19:54
|
| why use clr for this? cant you just use standard xml functions available in sql 2005 like nodes(),query() etc to get xml data to table or if sql 2000 or earlier use OPENXML for this? |
 |
|
|
|
|
|
Reading XML in CLR Stored Procedure