Table1 id,name
1,‘AA’
2,‘BB’
3,‘BB’
4,‘BB’
Table2 rq, tlb_name , value
'2015/02/25','Table1' , 'id=1'
触发器:
create trigger TR_DEL_Table1
on Table1
for delete as
declare @IDtmp int
declare @ID varchar
select @bucodetmp=(select id from deleted)
set @ID=CONVERT(varchar(10),@IDtmp)
begin
insert into Table2(rq,tblname,value )
values(getdate(),'Table1','id='+@ID)
end
若执行delete from Table1 where name='BB',Table2表中只能插入一条删除的记录。
我想要的效果是插入3条,分别是id=2,id=3,id=4的这3条记录。
怎么实现呢?