03 2015 档案

sql2005 将一列的多行内容拼接成一行
摘要：select ID, Name = ( stuff ( ( select ',' + Name from Table_1 where ID = a.ID for xml path('') ),1,1,'' )) from Table_1 a group by ID原始数据：I... 阅读全文
posted @ 2015-03-16 10:26 雨戈 阅读(243) 评论(0) 推荐(0)