--删除库存记录 use db declare @goods nvarchar(50) set @goods = '要删除的商品' --删除入库记录; delete from storeinfo where name = @goods --删除出库记录; delete from storeinfo2 where name = @goods