update语句，为空则不修改，不为空则更新

最新推荐文章于 2023-09-28 17:08:20 发布

lmy_loveF

最新推荐文章于 2023-09-28 17:08:20 发布

阅读量1k

点赞数

文章标签： sql

本文链接：https://blog.csdn.net/lmy_loveF/article/details/130109187

版权

 UPDATE  WAGES_INCOME_TAX_DIFFERENCE
            SET     witd_userid = @witd_userid ,
                    witd_department_id = @witd_department_id ,
                    witd_department_group_id = @witd_department_group_id ,
                    witd_taxsys_income_amount = @witd_taxsys_income_amount ,
                    witd_taxsys_tax_amount = @witd_taxsys_tax_amount ,
                    witd_income_amount = @witd_income_amount ,
                    witd_tax_amount = @witd_tax_amount ,
                    witd_remark = @witd_remark , 
                    witd_diff_reason =(case  where @witd_diff_reason!='' then  @witd_diff_reason else witd_diff_reason end 
											)  ,
                    witd_give_out_time = @witd_give_out_time ,
                    witd_edit_time = GETDATE() ,
                    witd_edit_userid = @witd_edit_userid
            WHERE   witd_id = @witd_id