declare @name nvarchar(100)
declare cur cursor for select name from syscolumns where id=object_id('表名')
open cur
fetch next from cur into @name
while @@fetch_status=0
begin
exec('update 表名 set jishu=jishu+isnull('+@name+',100)'
fetch next from cur into @name
end
close cur
deallocate cur