|
马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。
您需要 登录 才可以下载或查看,没有账号?注册账号
×
最近好多客户打来电话需要更改个人所得税的税率,于是自己写了一段语句还是很方便的。
select *from wa_sds_sl where isl_id=2 and period>7
select *from wa_sds_p where period>7
delete from wa_sds_sl where isl_id>7
update wa_sds_sl set yMax_level=1500,isl=3.0 where period>7 and isl_id=1
update wa_sds_sl set yMin_level=1500,yMax_level=4500,isl=10.0,ysskcs=105 where period>7 and isl_id=2
update wa_sds_sl set yMin_level=4500,yMax_level=9000,isl=20.0,ysskcs=555 where period>7 and isl_id=3
update wa_sds_sl set yMin_level=9000,yMax_level=35000,isl=25.0,ysskcs=1005 where period>7 and isl_id=4
update wa_sds_sl set yMin_level=35000,yMax_level=55000,isl=30.0,ysskcs=2755 where period>7 and isl_id=5
update wa_sds_sl set yMin_level=55000,yMax_level=80000,isl=35.0,ysskcs=5505 where period>7 and isl_id=6
update wa_sds_sl set yMin_level=80000,yMax_level=0,isl=45.0,ysskcs=13505 where period>7 and isl_id=7
update wa_sds_p set youtlay=3500,youtpluslay=4800 where period>7
需要注意的是,你要修改那个月的如果要修改9月份的就把 “7”改成8就行了。
修改完的税率表
|
|