定义外键约束:CREATE TABLE employee
(
worker_id int,
lname varchar(30) NOT NULL,
part_id char(4) NOT NULL
REFERENCES publishers(pub_id) --这里定义外键约束
)
(
worker_id int,
lname varchar(30) NOT NULL,
part_id char(4) NOT NULL
REFERENCES publishers(pub_id) --这里定义外键约束
)
as
declare @err int ,
@errmsg varchar(255),
@part_id varchar(10)
select @part_id=part_id from deleted if Exists(Select * From 員工表 Where part_id=@part_id)
begin
select @err=39999,@errmsg='此部門在使用中﹐不可刪除!'
goto error
end
return
error:
begin
rollback tran
raiserror @err @errmsg
end
return
as
if exites(select part_id from 部门表)
begin
print"不可刪除"
rollback tran
end