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 Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hauac3q/M=362131.6882499.7825260.1510227/D=groups/S=1705006764:TM/Y=YAHOO/EXP=1123667448/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/
