Convert sql data to xml format

Question

Hi,

I have data table in that table have a data that data will be convert in to xml format like
inside tag

example

 

<CPSMSStateSchemeMapping>

<StateCode>27</StateCode>

<FinancialYear>2013</FinancialYear>

<DepartmentCode>G</DepartmentCode>

<BudgetCode>0040000000000</BudgetCode>

<StateSchemeCode>24016241</StateSchemeCode>

< CPSMSSchemeCode>0404</CPSMSSchemeCode >

<CreatedDate >22/03/2013</CreatedDate>

</CPSMSStateSchemeMapping>