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
 SQL Server Development (2000)
 Views

Author  Topic 

misterraj
Yak Posting Veteran

94 Posts

Posted - 2005-09-19 : 08:03:56
Hi
I use a query like this:

select * from view for xml explicit

SQL results the data in xml format but when reading through a sqlreader in .Net the datas are getting truncated.

any one has faces simialr problems like this.if so please let me know.

venkat.

Kristen
Test

22859 Posts

Posted - 2005-09-19 : 13:32:30
I don't know anything about DotNet, but in case it helps you need to process XML resultsets as a STREAM rather than as a conventional RECORDSET.

Kristen
Go to Top of Page
   

- Advertisement -