CREATE TRIGGER MO_state ON MAINORDER FOR UPDATE,INSERT,DELETE
AS
BEGIN
DECLARE
@orderid VARCHAR(50),
@stateid VARCHAR(4)
IF UPDATE (MOSTATE)
BEGIN
SET NOCOUNT ON
select @orderid=MOORDERNO from deleted
select @stateid=MOSTATE from deleted
if @orderid is NULL
select @orderid=MOORDERNO from inserted
select @stateid=MOSTATE from inserted
update MAINDELIVER set STATE=@stateid where MAORDERID=@orderid
END
END
AS
BEGIN
DECLARE
@orderid VARCHAR(50),
@stateid VARCHAR(4)
IF UPDATE (MOSTATE)
BEGIN
SET NOCOUNT ON
select @orderid=MOORDERNO from deleted
select @stateid=MOSTATE from deleted
if @orderid is NULL
select @orderid=MOORDERNO from inserted
select @stateid=MOSTATE from inserted
update MAINDELIVER set STATE=@stateid where MAORDERID=@orderid
END
END
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货