请教一个事物的问题
2个表分别是
t1 有字段 A B C
t2 有字段 D E F
A字段为自增字段
需要写一个存储过程，向t1中添加数据，同时向t2中也添加数据D的值为刚向t1中添加数据的值，这个如何用事物实现？
[解决办法]
这个用触发器完成.
[解决办法]
--寫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
