create xml file from database table

Question

I have a data table named channel in ms sql server.In this table i have fields such as servername,sl,channelname,streamurl...i want to create a xml file for this table...i want xml file in this format

<channels playduration="">

   <channel name="" streamurl="" servername=""/> 

<channel name="" streamurl="" servername=""/>  

</channels>

please help me