update 中，等号左边有一项是空值，则左边结果也为空，如何解决？！

Question

例：UPDATE 2008 set x0011=x0111+x0211+x0311+x0411+x0511+x0611+x0711+x0811+x0911+x1011+x1111+x1211+x1311等号左边有一项是空值，则左边结果也为空

Answer 1

UPDATE 2008 set x0011 =  isnull(x0111,0)
                        +isnull(x0211,0)
                        +isnull(x0311,0)
                        +isnull(x0411,0)
                        +isnull(x0511,0)
                        +isnull(x0611,0)
                        +isnull(x0711,0)
                        +isnull(x0811,0)
                        +isnull(x0911,0)
                        +isnull(x1011,0)
                        +isnull(x1111,0)
                        +isnull(x1211,0)
                        +isnull(x1311,0) 

Answer 2

UPDATE 2008 set x0011=isnull(x0111,0)+isnull(x0211,0)+isnull(x0311,0)+isnull(x0411,0)+isnull(x0511,0)+isnull(x0611,0)+isnull(x0711,0)+isnull(x0811,0)+isnull(x0911,0)+isnull(x1011,0)+isnull(x1111,0)+isnull(x1211,0)+isnull(x1311,0)提示用于函数的参数个数不对！