select '(添加指定的内容)'+columnName from Table for xml path('') 转载于:https://www.cnblogs.com/TongWeiLv/p/10394014.html