急!sql 触发器 代码

来源：百度知道 编辑：UC知道 时间：2024/06/05 16:53:49
当删除表a的一条记录里,表b中aid=a.id的所有行都删除.这个代码应该如何写?
b中的aid和a中id都是int型.

a b 两表建立外键关系，a为主表b为外键表，关系是两表的id列
注意勾选 “级联删除”

使用约束也可以实现你得功能，使用触发器你可参考SqlServer得帮助(你得是SqlServer吗)

use tempdb
go
create table employee
(
emp_id int primary key ,
emp_name varchar(20) not null,
dept_id int not null,
)
create table department
(
dept_id int primary key,
dept_name varchar(20) not null,
)

insert into employee values(1,'zyy',1)
insert into employee values(2,'lzl',2)
insert into employee values(3,'gui',1)
insert into employee values(4,'ding',4)

update employee set dept_id=1 where emp_id=2

delete from department where dept_id=1

insert into department values(1,'软件部')
insert into department values(2,'人事部')
insert into department values(3,'软件部')

create trigger trigger_look
on employee instead of insert as
begin
if exists(select * from