OUTPUT clause in INSERT/UPDATE/DELETE statements

http://sholliday.spaces.live.com/Blog/cns!A68482B9628A842A!519.entry

做个标记。

 

insert into sysuser output [inserted].Id,[inserted].UserName values (‘username’)



delete from sysuser output [deleted].*



update sysuser set UserName = ‘updatevalue’ output [deleted].*,[inserted].* where id = 1