XML Output is Truncated in SQL
- by Muhammad Akhtar
Hi, I need to return my result set in XML and this works fine, but if the number of records are increased, my xml output is truncated here is my query
select t.id,t.name,t.address from test FOR XML AUTO, ROOT('Response'), ELEMENTS
However I have set some option to increase the output result set like..
Tools --> Options --> Query Results --> SQL Server --> Results to Text --> Maximum
number of characters displayed in each column
Tools --> Options --> Results --> Maximum characters per column
but still I am unable to get my desired result.
please suggest my solution
Thanks....