create procedure DeleteWareHouse_StoreArea_SummaryByPUR(@po_no nvarchar(100))as begindeclare @cacheTable table(wh_id int);--声明一个table类型的变量insert @cacheTable select wh_id from aps_inventory_store_area where description=@po_no--向变量@cacheTable中添加结果集--select * from @cacheTabledelete aps_inventory_summary where wh_id in(select * from @cacheTable)delete aps_inventory_store_area where wh_id in(select * from @cacheTable)delete aps_inventory_warehouse where wh_id in(select * from @cacheTable)end create procedure DeleteWareHouse_StoreArea_Summ 你的当前访问异常,请进行认证后继续阅读剩余内容。 提交