哦!对不起,我忘了说明白了,我的ACCESS2000是连接SQL SERVER7的!也就是说,ACCESS只是前工具而已。而且在SQL SERVER QUERY ANALYZER里也不行! 错误信息: The column prefix 'inserted' does not match with a table name or alias name used in the query.
主要是你的语句的from 中没有inserted和deleted表,系统报错,而且,你 在insert和delete中触发,肯定有一个是空表,所以,即使你的系统不报错 你也不能得到正确结果create Trigger article_Uintarticle On dbo.article For Insert, Delete As update member set intarticle=(select count(*) from article where article.idmember=inserted.idmember or article.idmember=deleted.idmember) where article.idmember=inserted.idmember or article.idmember=deleted.idmember我给你改了create Trigger article_Uintarticle On dbo.article For Insert, Delete As update member set intarticle=(select count(*) from (select * from deleted union from inserted) as a ) from article,(select * from deleted union from inserted) as b where article.idmember=b.idmember
错误信息:
The column prefix 'inserted' does not match with a table name or alias name used in the query.
在insert和delete中触发,肯定有一个是空表,所以,即使你的系统不报错
你也不能得到正确结果create Trigger article_Uintarticle
On dbo.article
For Insert, Delete
As
update member set intarticle=(select count(*)
from article
where article.idmember=inserted.idmember or
article.idmember=deleted.idmember)
where article.idmember=inserted.idmember
or article.idmember=deleted.idmember我给你改了create Trigger article_Uintarticle
On dbo.article
For Insert, Delete
As
update member set intarticle=(select count(*)
from (select *
from deleted
union
from inserted) as a
)
from article,(select *
from deleted
union
from inserted) as b
where article.idmember=b.idmember