Archive for March 20th, 2010

XML Output From SELECT Command in SQL Server 2005

XML is widely accepted platform-independent format for data presentation. Here, I am going to show some simple SQL ways to generate XML output from Database table or views in SQL Server 2005.

Let’s start with creating a Customer table and inserting those rows of data.
Continue reading