lyfz_repos/经典版源码/document/数据库维护脚本/选片按F5,全部相片都在删除里的恢复方法.sql

-- 选片按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 = '入册'