可是小花属于人事部,不符合业务逻辑不是很明白,试试IF EXISTS (SELECT name FROM sysobjects WHERE name = 't_dept' AND type = 'TR') DROP TRIGGER t_dept GOcreate trigger g_dept on 部门表 for insert asif ( not exists (select top 1 1 from 雇员表 a,inserted b where a.employeeid=b.managerid) begin raiseerror ('manager id not exist on 雇员表', 16, 1) rollback transaction endgo
WHERE name = 't_dept' AND type = 'TR')
DROP TRIGGER t_dept
GOcreate trigger g_dept on 部门表
for insert
asif ( not exists (select top 1 1 from 雇员表 a,inserted b where a.employeeid=b.managerid)
begin
raiseerror ('manager id not exist on 雇员表', 16, 1)
rollback transaction
endgo
是不是表写错了 自己好好看看 实在急你加我QQ