insert into Table2 select * from deleted
insert into Table2 select * from inserted
delete from table1
delete from table2
insert into table1 values('张三')
insert into table1 values('张三2')
update table1 set name = '张三_1 'where name = '张三'
update table1 set name = '张三_2 'where name = '张三2'
select * from table1
select * from table2
(所影响的行数为 1 行)
(所影响的行数为 1 行)
(所影响的行数为 1 行)
(所影响的行数为 1 行)
(所影响的行数为 1 行)
(所影响的行数为 1 行)
id name
----------- ----------
13 张三_1
14 张三_2
(所影响的行数为 2 行)
id name
----------- ----------
13 张三
13 张三_1
14 张三2
14 张三_2