用扫描枪扫描称重商品条码读取出一串数字

请备份数据库执行以下语句
use isszmbalv3
go
if not exists(select * from t_sys_system where sys_var_id = ‘IsUseKLD_Scanner’ and branch_no=’000′)
   insert into t_sys_system(sys_var_id,sys_var_name,sys_var_value,is_changed,sys_ver_flag,branch_no)
      values(‘IsUseKLD_Scanner’,”,’1′,’否’,”,’000′)
else
   update t_sys_system set sys_var_value=’1′ where sys_var_id=’IsUseKLD_Scanner’ and branch_no=’000′