create trigger [trgDeleteEuser]
on [dbo].[E_UserInfo]
for delete
as
delete Job_Info from Job_Info j join Deleted d on j.user_name=d.user_name
delete job_evaluation from job_evaluation e join Deleted d on e.user_name=d.user_name在线,急等