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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Parsing XML string from text column

Author  Topic 

vijayakumar_svk
Yak Posting Veteran

50 Posts

Posted - 2004-04-30 : 02:53:48
Hi,

I have one problem.First of all i will tell you the issue i have.
I am having an text column in a table.I store xml string in that column.i want to get the rows from that xml string.

i used sp_xml_preparedocument sp for parsing. but the second parameter for this sp is char,varchar i am unable to pass the test column data that parameter.

Any idea?

vijayakumar_svk@hotmail.com


Work smarter not harder take control of your life be a super achiever
   

- Advertisement -