-- 第一步;
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

*/