I'm guessing you are using Query Analyzer. The actual XML is being returned by SQL Server, but by default QueryAnalyzer only displays the first 256 characters of a column. RawXML gets returned in single column, so the display is getting clipped, but in your application the full XML string woould be available.
You can change the number of characters per column in Query Analyzer by sleecting Options... from the tools menu and changing the value on the Results tab. On 8/10/05, smartboy3k <[EMAIL PROTECTED]> wrote: > Hi all, > > im novice to SQL Server 2000. I have a problem while fetching records > from a table in XML stream format. Following is the SQL statement i > executed: > > USE PUBS > SELECT * FROM EMPLOYEE WHERE JOB_ID = 10 FOR XML RAW > > and it returned me XML stream which is not complete. The above > statement gave me results as below > > XML_F52E2B61-18A1-11d1-B105-00805F49916B > ---------------------------------------- > <row emp_id="A-C71970F" fname="Aria" minit=" " lname="Cruz" > job_id="10" job_lvl="87" pub_id="1389" hire_date="1991-10- > 26T00:00:00"/> > <row emp_id="PHF38899M" fname="Peter" minit="H" lname="Franken" > job_id="10" job_lvl="75" pub_id="0877" hire_date="1992-05-17 > > Can anyone let me know what the problem is what wud be its solution > > Thanks in Advance > Avinash > > > > > > > > Yahoo! Groups Links > > > > > > > -- Dean Fiala Very Practical Software, Inc http://www.vpsw.com ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hi5bp6q/M=362131.6882499.7825260.1510227/D=groups/S=1705006764:TM/Y=YAHOO/EXP=1123772747/A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org ">Get Bzzzy! (real tools to help you find a job) Welcome to the Sweet Life - brought to you by One Economy</a>.</font> --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
