delete pos_scale_temp_item   /*清除传秤页面‘被其他用户修改或删除’*/

/*把5位货号的普通商品的货号前面加8888*/ SET QUOTED_IDENTIFIER OFF go if exists(select 1   from item a  inner join item b on b.item_no = right('8888' + rtrim(a.item_no), 9) an...

--解决销售时所属仓库错了 use tigerzz go if not object_id('tempdb..#a') is null   drop table #a declare @adt_from datetime, @adt_to datetime, @err_branch varchar(4), @right_bra...