跟小D每日学口语

将同一列的值用逗号分隔连接成一个字符串



DECLARE @FIDs VARCHAR(8000) SELECT @FIDs = COALESCE(@FIDs + ', ', '') + CAST(FID AS VARCHAR(10)) 

FROM CCC_TADetail 

WHERE AppointId=1600

SELECT @FIDs as FIDs

posted @   Danny Chen  阅读(445)  评论(0编辑  收藏  举报
努力加载评论中...
点击右上角即可分享
微信分享提示