Monthly Archives: April 2006

Save xml document created by FOR XML to a variable

In SQL Server 2000, the xml created by FOR XML clause cannot be saved in server side. It has to be returned to client directly. This is very inconvient if you want to cache or persist the created xml. The … Continue reading

Posted in SQL server 2005 | 2 Comments