我希望得到A表新增加的行的关键字 然后通过这个关键字查找另一个表修改对应的内容CREATE TRIGGER InsNew ON Lend
FOR INSERT
AS
UPDATE Reader
Set R_Amount=R_Amount+1
Where R_ID= 新增加的行的R_ID是不是用select 查询 inserted表呢?
应该怎么得到 这个R_ID ?
我本来以为可以这样写: Where R_ID= Select R_ID From inserted
但是不行请问怎么解决 谢谢!
FOR INSERT
AS
UPDATE Reader
Set R_Amount=R_Amount+1
Where R_ID= 新增加的行的R_ID是不是用select 查询 inserted表呢?
应该怎么得到 这个R_ID ?
我本来以为可以这样写: Where R_ID= Select R_ID From inserted
但是不行请问怎么解决 谢谢!
FOR INSERT
AS
update a
set R_Amount=a.R_Amount+b.con
from
Reader a
join
(select R_ID,count(*)con from inserted group by R_ID )b on a.R_ID=b.R_ID
CREATE TRIGGER InsNew ON Lend
FOR INSERT
AS
UPDATE Reader
Set R_Amount=R_Amount+1
Where R_ID= i.R_ID
from inserted i
--顺序搞反了.
CREATE TRIGGER InsNew ON Lend
FOR INSERT
AS
UPDATE Reader
Set R_Amount=R_Amount+1
from inserted i
Where R_ID= i.R_ID
FOR INSERT
AS
update a
set R_Amount=a.R_Amount+1
from
Reader a
where
exists(select 1 from inserted where R_ID=a.R_ID)--一條一條新增時可用