表 tblSpecialItem1 内增加触发
CREATE TRIGGER hongte ON dbo.tblSpecialItem1
FOR UPDATE
AS
set nocount on
DECLARE @id int ,@map int
SELECT @id=id FROM INSERTED
if update(Position)
begin
UPDATE tblSpecialItem1 SET ItemDurability=-1 WHERE id=@id
end
但这个不是掉出红特,而是捡起来变成红特
|