摘要:
例如:test表一、拼接多个字段的值select Convert(nvarchar(50),id)+'-'+name+'-'+sex as montage from test结果:二、一个字段多条记录的拼接select stuff((select '-'+name from test for xml path ('')),1,1,'') as montage结果:功能解析:①stuff:1、作用stuff(param1, startIndex, length, param2)将param1中自startIndex( 阅读全文