Tip - How to Make XML Look Pretty in SQL Server Result | eHow

Making XML look pretty in a Microsoft SQL Server result set is moderately easy, given a proper set of tools and technique. Whether using SQL Server 2000, 2005 or 2008, producing easy-to-read, well-indented, and well-formed XML is very doable. The output can be generated using SQL Server Management Studio or even the command line "bcp" utility.