Question

SQL语句delete from 后‘，’报错说‘，’有语法错误

create trigger delete_XS
on XS_Info for delete
as
delete from CJ_Info,deleted
where CJ_Info.Stu_ID=deleted.Stu_ID

Answer 1

删除语句不能这么写的。

改为
delete from CJ_Info
where Stu_ID in (select Stu_ID from deleted)

Answer 2

一楼回答是对的！