create trigger tr_deletetest
on temp_student1
after delete
as
delete from Temp_student2,deleted where Temp_student2.student_id=deleted.studentid
on temp_student1
after delete
as
delete from Temp_student2,deleted where Temp_student2.student_id=deleted.studentid
create trigger tr_deletetest on temp_student1
after delete
as
delete from Temp_student2 a where a.student_id in(select student_id from deleted)
on temp_student1 A
for delete
as
delete Temp_student2 B where B.student_id=(select A.student_id from delete)
create trigger tr_deletetest
on temp_student1
after delete
as
delete t ---这个地方你没有写要删除的表,我这里用的是别名
from Temp_student2 t inner join deleted d on t.student_id=d.studentid ---这个地方是两个表的连接
on temp_student1
after delete
as
错误所在: delete from Temp_student2,deleted where Temp_student2.student_id=deleted.studentid 可改为:
DECLARE @SID VARCHAR(10)
SELECT @SID=studentid FROM DELETED
DELETE TEMP_STUDENT2 WHERE student_id=@SID