https://www.cnblogs.com/friday69/p/9389720.html
Sql Server中实现Mysql中的group_concat函数效果
SELECT stuff((select ',' + PUD_Dept from PB_User_Dept t where PUD_User = PUB_ID for xml path('')) , 1 , 1 , '')
FROM [dbo].[PB_User_Base]
posted on
2020-01-04 11:26
人淡如菊
阅读(468)
评论()
收藏
举报