CREATE trigger UT_StoreItemDelete
on StoreItem
for Delete
as
begin
declare
@id int,
@IMEI varchar(15) select @IMEI =(select IMEI from deleted)
select top 1 @id=id from product where IMEI=@IMEI and status<>0 order by id desc
update Product set Status=SaveStatus,SaveStatus=Status where id=@id
end
--------------------
这是我编的触发器,一次删除多条没问题,但是删除多条就有问题。
on StoreItem
for Delete
as
begin
declare
@id int,
@IMEI varchar(15) select @IMEI =(select IMEI from deleted)
select top 1 @id=id from product where IMEI=@IMEI and status<>0 order by id desc
update Product set Status=SaveStatus,SaveStatus=Status where id=@id
end
--------------------
这是我编的触发器,一次删除多条没问题,但是删除多条就有问题。
on StoreItem
for Delete
as
update Product
set Status=SaveStatus
,SaveStatus=Status
from Product A
join deleted D on D.IMEI=A.IMEI
where A.id =(select top 1 id
from product
where IMEI=D.IMEI
and status<>0
order by id desc)