stuff((select ','+LTRIM( RTRIM(FBatchNumber) ) from #t9tel where FNumber=t1.cardnumber for xml PATH('') ), 1, 1, '')
sqlserver 多行值用逗号隔开
最新推荐文章于 2024-01-22 17:02:56 发布
stuff((select ','+LTRIM( RTRIM(FBatchNumber) ) from #t9tel where FNumber=t1.cardnumber for xml PATH('') ), 1, 1, '')