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 |
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
 Posted - 2002-04-30 : 13:02:41
|
| Running the following queryselect *FROM OPENQUERY(TEST,'select FirstName,LastName from Northwind.dbo.Employees for xml raw')returns an image datatype that seems to be some sort of binary stringIs there any way either via ADO or SQLXML or TSQL to decode this into the same result as select FirstName,LastName from Northwind.dbo.Employees for xml rawTIAJasper Smith |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-04-30 : 14:33:29
|
| If you are getting XML from SQL Server using ADO, you should use a Stream object instead of a recordset object. The XML results can't be represented properly in a recordset, so ADO will probably treat it as an image column since it is intended to store binary streams of data. |
 |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-04-30 : 15:58:19
|
| This is in Query Analyzer though.I'm just wondering if I can convert the result into XML (preferaby using convert/cast etc. I'm basically trying to workaround not being able to insert the result of a FOR XML statement into a text column(or into anything for that matter)CheersJasper |
|
|
|
|
|
|
Openquery with FOR XML returns Image datatype