none
FOR XML EXPLICIT Query returns only one row

    Question

  • It looks to me like any FOR XML EXPLICIT query that produces more than 2k of XML gets truncated after the first row.
    This is surprising, as the equivalent view, executed in design mode within Management Studio with the FOR XML EXPLICIT extension added, returns all of the XML, in multiple rows if needed.
    Hopefully, you have seen this before and can explain.  What I am trying to do is generalize work originally done with views, using functions and parameters.
    I am running SQL Server 2005 SP3.
    I will produce an example using the Adventure Works database, if you'd like.
    Thanks
    Monday, April 20, 2009 4:45 PM

All replies