-- 选片按F5,全部相片都在删除里的恢复方法; use [db] declare @order nvarchar(50) set @order = '20150918-001' -- 订单号; update dindan set [delphotos] = NULL where id = @order update dindansp set [no] = '001,002,002,004' where id = @order and name = '入底' update dindansp set [no] = '001,002,002,004' where id = @order and name = '入册'