--一个空值加另外一个空值永远为空
update bo_sfa2_contract set PAYAMOUNT=PAYAMOUNT+10000 where no='2008HX07001'
select PAYAMOUNT,* from bo_sfa2_contract where no='2008HX07001'
结果不为null
update bo_sfa2_contract set PAYAMOUNT=ISNULL(PAYAMOUNT,0)+10000 where no='2008HX07001'
select PAYAMOUNT,* from bo_sfa2_contract where no='2008HX07001'