| 123456789101112131415161718192021222324 |
- -- 第一步;
- use db
- declare @order nvarchar(50)
- set @order = '20160326-001'
- -- 先查找指定的订单号的商品信息;
- select * from dindansp where id = @order
- /*
- -- 第二步;
- use db
- go
- declare @order nvarchar(50)
- declare @spname nvarchar(50)
- declare @spid nvarchar(50)
- set @order = '订单号'
- set @spname = '婚庆服务名'
- set @spid = '婚庆服务id'
- delete from dindansp where id = @order and spid = @spid and name = @spname
- */
|
