create trigger st1 on student after update as declare @sno int select @sno = sno from deleted update score set sno=@sno--不知道怎么判断 这个是我做的,但是在最后不知道要怎么判断
没有Student除了学号,更新的时候没有不变的id吗
create trigger st1 on student after update as declare @sno int select @sno = sno from deleted update score set sno=@sno WHERE ID IN(SELECT ID FROM DELETED)
不是吧 inserted,deleted会有多条吧
create trigger st1 on student after update as declare @sno int select @sno = sno from deleted update score set sno=@sno WHERE ID IN(SELECT ID FROM INSERTED) 是这个弄错了,呵呵,并发问题不知道呢
create trigger st1 on student after update as declare @sno int select @sno = sno from deleted update score set sno=@sno WHERE ID IN(SELECT ID FROM INSERTED) 就是这样,deleted和INSERTED存的第一条记录就是最新删除和最新更新的记录
没有id字段哦我运行了也提示出错:列名 'ID' 无效。
create trigger st1 on student after update as declare @sno int select @sno = sno from deleted update score set sno=@sno WHERE sno IN(SELECT sno FROM INSERTED)
create trigger st1 on student after update as declare @sno varchar(20),@sno1 varchar(20) select @sno = sno from inserted select @sno1=sno from deleted update score set sno=@sno where sno=@sno1
on student
after update
as
declare @sno int
select @sno = sno from deleted
update score set sno=@sno--不知道怎么判断
这个是我做的,但是在最后不知道要怎么判断
on student
after update
as
declare @sno int
select @sno = sno from deleted
update score set sno=@sno WHERE ID IN(SELECT ID FROM DELETED)
on student
after update
as
declare @sno int
select @sno = sno from deleted
update score set sno=@sno WHERE ID IN(SELECT ID FROM INSERTED)
是这个弄错了,呵呵,并发问题不知道呢
create trigger st1
on student
after update
as
declare @sno int
select @sno = sno from deleted
update score set sno=@sno WHERE ID IN(SELECT ID FROM INSERTED)
就是这样,deleted和INSERTED存的第一条记录就是最新删除和最新更新的记录
没有id字段哦我运行了也提示出错:列名 'ID' 无效。
on student
after update
as
declare @sno int
select @sno = sno from deleted
update score set sno=@sno WHERE sno IN(SELECT sno FROM INSERTED)
on student
after update
as
declare @sno varchar(20),@sno1 varchar(20)
select @sno = sno from inserted
select @sno1=sno from deleted
update score set sno=@sno where sno=@sno1