Hi everybody!
A silly question, but I can not go further!
I have this statement
USE Northwind
SELECT Customers.CustomerID, ContactName, CompanyName, Orders.CustomerID, OrderDate
FROM Customers, Orders
WHERE Customers.CustomerID = Orders.CustomerID AND (Customers.CustomerID = N'ALFKI' OR Customers.CustomerID = N'XYZAA')
FOR XML AUTO, ELEMENTS
I'm trying to copy the result displayed in the Query Analyzer in the Grids Panel and paste it into a notepad file, so that I can see the result in IE. But when I copy the result, the xml file is not complete. It's only 256 characters long. You can try the example with the northwind database.
Thank you very much!
Radu