任务调度.sql

来自「主要实现管理客户以及客户信息和其公司的服务管理」· SQL 代码 · 共 16 行

begin transaction
declare  @cid int ,  @date datetime,@errornum int
set @errornum = 0
select @cid=o.Customers_Id,@date=Orders_Datetime from orders as o join customers as c
on c.customers_id=o.customers_id where
 datediff(month,Orders_Datetime,getDate()) =5 and c.customers_status=1
set @errornum=@errornum+@@error
insert into Lost(Lost_LastOrderDatetime,Customers_Id,Lost_Status) values(@date,@cid,1)
set @errornum=@errornum+@@error
update customers set customers_status = 2 where customers_id= @cid
set @errornum=@errornum+@@error
if(@errornum!=0)
 rollback transaction
else
  commit transaction