使用Microsoft SQL Server Management Studio导出XML数据类型列

I have a table with 2 columns. The column response is an XML data type column (I am able to click on it an open the XML document). I would like to have a code that would export each row of the column response into an XML document saved on my desktop. Path = I have a table with 2 columns. The column respo