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 |
|
krishnan
Starting Member
3 Posts |
 Posted - 2002-02-28 : 11:59:54
|
| Hi,Iam accepting an xml as an input parameter in the SP.if the input xml contains <ROOT><Info><Id>4</Id><cname>abc1</cname>........</Info></ROOT>When i do select * from openxml(@idoc,'/ROOT/Info',2) it works....But openxml fails when the input xml contains something like this<ROOT xnlms="xmlschema:abc.xdr"><Info><Id>4</Id><cname>abc1</cname>.....</Info></ROOT>Can anyone tell why is this and whatz the workaround.Thanks,Sajai. |
|
|
|
|
|
OPENXML