weixin_42781191的博客

解决方法： 1， 打开查询分析器，选择好对应的药店数据库名称，复制如下语法执行： use hzposyy_zq if EXISTS(SELECT * FROM sysobjects WHERE name = 'salepos_2012') drop table salepos_2012 select item_no into salepos_2012 from pos_sale_detail where approve_flag<>'1' and branch_no='0001' and (item_no not in (select item_no from base_warehouse_qty where branch_no='0001') or item_no in(select item_no from base_warehouse_qty where branch_no='0001' and isnull(batch_no,'')='')) update a set a.have_batch='0' from base_goods a , salepos_2012 b where a.item_no =b.item_no 复制上面的代码，打开查询分析器，打开后数据库没有密码，直接点击确定，想代码复制上去，点执行按钮