--寫trigger create trigger tr_t1_i on t1 for insert as insert t2 select * from inserted
CREATE TRIGGER mytrigger ON t1 FOR INSERT AS insert into t2(d) select max(a) from t1 GO
CREATE TRIGGER mytrigger ON t1 FOR INSERT AS insert into t2 select * from t1 GO 或 CREATE TRIGGER mytrigger ON t1 FOR INSERT AS insert into t2 select * from t1 where a in (select max(a) from t1) GO
create trigger tr_t1_i on t1 for insert
as
insert t2
select * from inserted
AS
insert into t2(d) select max(a) from t1
GO
AS
insert into t2 select * from t1
GO
或
CREATE TRIGGER mytrigger ON t1 FOR INSERT
AS
insert into t2 select * from t1 where a in (select max(a) from t1)
GO