CREATE TABLE #disable_u_distapply_m(id int)
UPDATE dbo.u_distapply_m SET status=2 WHERE applyno=”
DROP TABLE #disable_u_distapply_m create table #disable_u_distapply_m(id int)
update u_distapply_m
set status=’2′(单据状态)
where billcode=’APD’ and applyno=’151009003200006’(店间调拨单)
drop table #disable_u_distapply_m
|