SQL 新特性 output

output 可以把对表的：添加，删除，更新操作数据插入临时表。

create table #tb(id int,name varchar(32));
declare  @tb table(id int,name varchar(32));
/* 添加
insert into #tb(id,name) 
output inserted.id,inserted.name
    into @tb
    values(1 ,'AAA' ) 
*/
/* 删除
delete #tb
output deleted.id,deleted.name
    into @tb
 where id=1
*/
--更新
update #tb set name=name+'1'
 output deleted.id,deleted.name
    into @tb
 where id=2
select * from @tb