如果楼主想获得每个SQL语句影响到的行,只能使用SQLSERVER触发器中提供的deleted和inserted虚拟表.最好分别创建insert,update,delete触发器,在触发器中将根据需要有选择地把这二个表中的数据插入到自己创建的日志表中(使用insert...select...),用于跟踪表的变化.注意要把插入到日志表这个操作放到事务中.
如果楼主想测试触发器中被影响的行,可以在触发器中使用select查询一下.如:
create trigger trigger_i on yourtable
for insert
as
select 'insert.inserted',* from inserted
select 'insert.deleted',* from deleted
go
create trigger trigger_u on yourtable
for update
as
select 'update.inserted',* from inserted
select 'update.deleted',* from deleted
go
create trigger trigger_d on yourtable
for delete
as
select 'delete.inserted',* from inserted
select 'delete.deleted',* from deleted
go