Sql server存储过程中 数据集的缓存

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