for XML....

While using below SQL statment in 'SQL Query Analyser' i dont get the compelete XML in the result.... (there is no columns of type 'Memo' or any long fields more than 1K characters)

Problem i'm facing is:
1. there are 6 rows in the table, but i'll get only first row in XML and not the rest of XML (for the Ex1 in code)

2. For the Ex2 in below code - there are more than 1000 rows, but i get only very few of them in resulted XML...


what is wrong in my 'Query' or 'Query Analyser' ??

Thx in Adv.

Code:

---

  Ex1:
  select * from T_Application for XML auto

---

Code:

---


  Ex2:
  select * from T_EmploymentDetails for XML auto

---