发生了业务的商品档案都是删不了的。只能停用。
在查询分析器中选择要操作的赢通数据库。执行下面语句
--库存数为0的商品停用
if object_id ('bb','u') is not null
drop table bb
select item_no,sum(stock_qty)stock_qty into bb from t_branch_stock group by item_no order by stock_qty
update t_item_info set display_flag ='0' where item_no in( select item_no from bb where stock_qty=0) or item_no not in(select item_no from t_branch_stock)
if object_id ('bb','u') is not null
drop table bb