Sql Server触发器 怎样将一个表中的某一条数据删除后然后将这一条数据插入到另一个表中？

--创建测试表create table t_a(id int,name varchar(10));create table t_b(id int,name varchar(10));--测试数据insert into t_a(id,name) values (1,'a');--创建 for delete 触发器create trigger trg_t_a_1 on t_afor deleteasbegininsert into t_b select id,name from deleted