现在有数据表TableA,TableB
触发器要求:
当TableA被批量删除数据时,TableB也被批量删除相同数据。------------------------------------------------------------------------TableB也被批量删除相同数据。 ---相同记录条数?两个表的关联字段?
触发器要求:
当TableA被批量删除数据时,TableB也被批量删除相同数据。------------------------------------------------------------------------TableB也被批量删除相同数据。 ---相同记录条数?两个表的关联字段?
on tablea
for delete
as
delete from tableb where exists (select 1 from deleted)
go
有两张TableA,TableB
两张都有字段visittime,并且都不会重复
先要求触发器功能:
当TableA执行,delete from TableA where visittime between '2006-1-1' and '2006-1-23'
将TableB中,符合between '2006-1-1' and '2006-1-23'
create table A
(
T_name varchar(10),
T_date datetime
)create table B
(
T_name varchar(10),
T_date datetime
)insert A select 'sc','2006-1-1'
insert A select 'sdfs','2006-1-2'
insert A select 'dfssc','2006-1-3'
insert A select 'sdf','2006-1-23'insert B select 'sc','2006-1-1'
insert B select 'sdfs','2006-1-2'
insert B select 'dfssc','2006-1-3'
insert B select 'sdf','2006-1-23'
create trigger TEMP_SC ON A
AFTER delete
as
delete B from B where T_date between (select min(T_date) from deleted) and (select max(T_date) from deleted)delete A from A where T_date between '2006-1-1' and '2006-1-23'select * from A
select * from B
测试通过