Representing XML data in SQL Server

In this article, we will see how to use the FOR XML statement in SQL Server to represent the result of queries in XML format.

Formatted output

Creating a comma-separated list (SQL Spackle)

Learn how to create a comma separated list of values in this short SQL Spackle article by Wayne Sheffield.

Using FOR XML clause to generate KML

Creating KML files for many of the GIS applications such as Google Earth can be an easy and rich part of your business intelligence efforts

RE: sql server won''''t start, restore only option?

I would try and attach the files on another server, I believe it should work and no data should be corrupted., do a dbcc checkdb after the attach. Make a backup of the mdf & ldf files just in case. Wont hurt to try and BOL is best practice guide, this is an emergency

RE: Problem with Temporary tables

I have rebooted the PC, restarted Query Analyser, loaded the script and hit the Run button. I still get the same error. The problem presumably is that the parser sees the temporary table being created in two places and assumes that it already will exist when it hits the second one (not understanding that it […]

RE: procedure

No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!

RE: paging - showing 10 records at a time, etc.

check out the article here: there are some discussons and examples of how this can be done. http://qa.sqlservercentral.com/columnists/jwiner/moreonreturningasubsetofarecordset_1.asp