删除库存记录.sql 197 B

12345678910
  1. --删除库存记录
  2. use db
  3. declare @goods nvarchar(50)
  4. set @goods = '要删除的商品'
  5. --删除入库记录;
  6. delete from storeinfo where name = @goods
  7. --删除出库记录;
  8. delete from storeinfo2 where name = @goods