您正在寻找FOR XML选项。请参阅 https://msdn.microsoft.com/en-us/library/ms178107.aspx [ ^ ]

The FOR XML option is what you are looking for. See https://msdn.microsoft.com/en-us/library/ms178107.aspx[^]