思迅专卖10门店寄存捆绑商品语句

use isszmv10
go
   update t_sys_system set sys_var_value = '1' where sys_var_id='can_dep_kunbang_item' and branch_no='000'
go
if not exists(select 1 from t_sys_system where sys_var_id='can_dep_kunbang_item' and branch_no='000')
   insert into t_sys_system(sys_var_id, sys_var_name, sys_var_value)
 values('can_dep_kunbang_item','门店系统可以寄存捆绑商品','1')
go

关闭此功能
update t_sys_system set sys_var_value = '0' where sys_var_id='can_dep_kunbang_item' and branch_no='000'