How to Make XML Look Pretty in SQL Server Result

How to Make XML Look Pretty in SQL Server Result – This is a place for the community to provide tips and advice on How to Make XML Look Pretty in SQL Server Result. This topic was created by adman 1 and the tips are provided by the community. The tips you add here can be your own or referred from another site. The best tips are then ranked at the top when up-voted by members of the community.

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

Published:  | Submitted by Paula Leichen | permalink
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.

Tip 2 - How to make sql query result to xml file

Published:  | Submitted by Jamil Haddad | permalink
How to make sql query result to xml file

I have an sql query, selects some data from a table. ID Name Number Email 1 a 123 a@a.com 2 b 321 b@b.com 3 c 432 c@c.com I get these

About Author

More by adman 1

No more topics...

About This Topic

Category: Fun | 9 years, 8 month(s) ago

14.7k+ Reads
2 Tips
2 Votes
0 Likes
0 Saved

Contributors