declare @s varchar(8000)
set @s=''
select @s=@s+'+isnull('+name+',0)' from syscolumns
where id=object_id('表名') and name like 'STORE%'
set @s=substring(@s,2,8000)
exec('update 表 set sumAmount='+@s)
declare @s varchar(8000)
set @s=''
select @s=@s+'+isnull('+name+',0)' from syscolumns
where id=object_id('表名') and name like 'STORE%'
set @s=substring(@s,2,8000)
exec('update 表 set sumAmount='+@s)