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'