建立触发器问题!
检查订单表,如果删除的雇员没有接受订单,可以删除该雇员信息,否则撤消删除,显示“不能删除该雇员!”信息。
create trigger tri_employee_del
	on Employee
	after delete
as
	declare @var_雇员ID int
	if exists(select * from P_order where 雇员ID=@var_雇员ID)
		delete from Employee where 雇员ID=@var_雇员ID
	else
		print(不能删除该雇员!)
		rollback
go
delete Employee
	where 雇员ID=7
go
请问哪里出错了!!!