How can I create a txt file in xml using Sql server?

How can i create the below xml file from sql server?

<Database>
<Tables>
<Table Name="Student"> <Files> <File FileName="Student_Info.txt" NumberOfRows="44" /> </Files>
<Columns>  
<Column Name="Name" DataType="nvarchar" Length="50" /> 
<Column Name="Department" DataType="nvarchar" Length="30" /> 
 <Column Name="Phone" DataType="nvarchar" Length="20" /> 
</Columns>  </Table> 
<Table Name="Teacher">
<Files>
<File FileName="Teacher.txt" NumberOfRows="33"  />
</Files>
<Columns>
<Column Name="TID" DataType="ANSI INTEGER" IsPrimaryKey="true" />
<Column Name="TName" DataType="ANSI CHARACTER VARYING" Length="50" />
</Columns>
</Table>
</Database>

Here I want to make a database where all table data will save in a txt file and the Number of rows will change everytime.