
July 7th, 2004, 03:20 AM
|
|
Registered User
|
|
Join Date: Jul 2004
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
For XML Query not returning all the rows
I used
Select * from tbltrainerstate for xml auto // in sql server2000 query analyser
Table tbltrainerstate has 40 records but this query is only showing 7 records in xml format.
What i did is, I copied all records from the result using select All and copy option and then pasted that in a notepad.
Do anyone can tell why this is not showing all the records.
and how can i display each record in different row , because it is showing the records in the single row.
|