22,209
社区成员
发帖
与我相关
我的任务
分享
CREATE table score
(cno varchar(10))
CREATE table course
(cno varchar(10))
INSERT INTO score SELECT '001'
INSERT INTO course SELECT '001'
CREATE TRIGGER tr_Update ON course FOR UPDATE
AS
BEGIN
declare @DeleteCno int
declare @InsertCno int
select @DeleteCno=cno from deleted
select @InsertCno=cno from inserted
update score set cno=@InsertCno where cno=@DeleteCno
END
UPDATE course SET cno ='002' WHERE cno='001'
if object_id('tri_test')is not null
drop trigger tri_test
go
create trigger tri_test on tb
for update
as
update 成绩表
set cno=i.cno from inserted where i.标识列=成绩表.标识列