create trigger tr
on a
for insert
asinsert b(bid,其他字段列表.....)
select aid,
其他字段列表......
from insertedgo
on a
for insert
asinsert b(bid,其他字段列表.....)
select aid,
其他字段列表......
from insertedgo
SELECT *
FROM deleted