FOR INSERT(插入)|DELETE(刪除)|UPDATE(更新)
AS
declare @username varchar(50)//自定義@母表字段
select @username=UserName from inserted
insert 需要更新的表字段(類型) values( @username)
就這樣,不懂在問我吧
下面例子:
CREATE TRIGGER [tgUser] ON dbo.Users
FOR DELETE
AS
declare @username varchar(50)
select @username=UserName from inserted
insert Score (ID) values( @username)
當我向users表刪除username的時候同時在score表刪除這個ID