看来 LZ 只需要有一个update触发器就好了,建在mainstudenttb表上ALTER TRIGGER [UPDATE_FOR_mainstudenttb] ON [mainstudenttb]
FOR UPDATE
AS
UPDATE secondstudenttb SET oper = INSERTED.oper FROM INSERTED
WHERE secondstudenttb.realname = INSERTED.realname
GO
FOR UPDATE
AS
UPDATE secondstudenttb SET oper = INSERTED.oper FROM INSERTED
WHERE secondstudenttb.realname = INSERTED.realname
GO
就不能这样写
因为当你在表mainstudenttb上Update时
由于realname是主键,所以两表无法进行关联
---------------------------------------
/*假如两表是通过ID关联的话,可以这样写*/
Create Trigger Tri_Test On mainstudenttb
For Update
As
If Update(realname)
Begin
Update T Set T.realname=i.realname
From secondstudenttb T
Inner Join Inserted i On T.id=i.id
Inner Join Deleted d On T.id=d.id
End
Go
FOR UPDATE
AS
UPDATE secondstudenttb SET realname= INSERTED.realname FROM INSERTED
WHERE secondstudenttb.realname = DELETED.realname
GO
大有感触啊
改下他的一小小错误
-------------------------------
Create Trigger Tri_TestM On mainstudenttb
For Update
As
If Update(realname)
Begin
Update secondstudenttb
Set realname=i.realname
From
Inserted i,Deleted d
Where secondstudenttb.realname=d.realname
End
GO