sql查询过程中 update,insert,delete可视化收影响行数

insert into test_tb output inserted.id,inserted.data  values('c'),('d')
delete from test_tb output deleted.id where data='c'
update test_tb set data='abc' output inserted.id  as ID ,deleted.data as old_data ,inserted.data as new_data where data='c'

with temp_tb as
(
  select id,data from test_tb where data='abc'
)
update temp_tb set data='123'

 

posted on 2014-12-29 14:37  魔GUI  阅读(354)  评论(0编辑  收藏  举报

导航