触发器的问题

[sh0cker]

不是说内存中有个deleted的表吗？
帮助中还说能用select * from deleted查询
可是怎么提示说表名无效？

CREATE TRIGGER del_starin_movietitle
ON movie FOR DELETE
AS
delete
from starin
where starin.movietitle = (select movie.title
from movie,deleted
where movie.title=deleted.title)

帮我看看这个写的对不对

[sasacat]

Deleted 表用于存储 DELETE 和 UPDATE 语句所影响的行的复本。在执行 DELETE 或 UPDATE 语句时，行从触发器表中删除，并传输到 deleted 表中。Deleted 表和触发器表通常没有相同的行。

你写的改成

CREATE TRIGGER del_starin_movietitle
ON movie FOR DELETE
AS
delete
from starin
where starin.movietitle = (select starin.movietitle 　　　　　　　　　from starin,deleted
where starin.movietitle =deleted.title)

就可以了

[foolishchao]

CREATE TRIGGER del_starin_movietitle1
ON movie FOR DELETE
AS
delete starin
from starin s,deleted d
where s.movietitle =d.title

go