sql更新相同字段的值的另外字段累加到一起
wxfhj521
2013-09-10
比如说一个表里面字段A 字段B a xxxxx a ccccc a ddddd 要的结果为 a xxxxxcccccddddd
满意答案
hyhaust
LV12
2013-09-11declare @c varch来自ar(max)
dec360问答lare @tab table ( a varchar(10) )
inse极副研呀奏龙笔财rt @tab ( a )
select 'aaa'
union select 'cccc'
union select 'dddd'
select @c = ''
select @c = @c + a from @t将ab
print @c
00