Please any one tell me, how to generate following XML using FOR XML in SQL server 2008,
There is three columns First_Name, Middle_Name and Last_Name and I want to select all data of thease column using /Row/Cell/Data tags. I am waiting for your reply :)
<?xml version="1.0" encoding="utf-16"?>
<ss:Workbook xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet">
<ss:Styles>
<ss:Style ss:ID="1">
<ss:Alignment ss:Horizontal="Left" />
<ss:Font ss:Bold="1" />
</ss:Style>
<ss:Style ss:ID="2">
<ss:Alignment ss:Horizontal="Right" />
</ss:Style>
<ss:Style ss:ID="3">
<ss:Alignment ss:Horizontal="Center" />
</ss:Style>
</ss:Styles>
<ss:Worksheet ss:Name="F.Y.B.A. -2009-2010">
<ss:Table>
<ss:Column ss:AutoFitWidth="0" ss:Width="40" />
<ss:Column ss:AutoFitWidth="0" ss:Width="102" />
<ss:Column ss:AutoFitWidth="0" ss:Width="84" />
<ss:Row>
<ss:Cell>
<ss:Data ss:Type="String">First_Name</ss:Data>
</ss:Cell>
<ss:Cell>
<ss:Data ss:Type="String">Middle_Name</ss:Data>
</ss:Cell>
<ss:Cell>
<ss:Data ss:Type="String">Last_Name</ss:Data>
</ss:Cell>
</ss:Row>
<ss:Row>
<ss:Cell>
<ss:Data ss:Type="String">ABHILASH</ss:Data>
</ss:Cell>
<ss:Cell>
<ss:Data ss:Type="String">RAMDEV</ss:Data>
</ss:Cell>
<ss:Cell>
<ss:Data ss:Type="String">SHRIYAN</ss:Data>
</ss:Cell>
</ss:Row>
</ss:Table>
</ss:Worksheet>
</ss:Workbook>