You can seen that XML is now every where to exchange data between multiple system and platform. Here are sample query which retrieve XML of particular Table's data. XML support is available on SQL Server 2000 with SQLXML 3.0 and its XML extensions, and There are in built native XML data type support in SQLServer 2005 and 2008.


















