34,576
社区成员
发帖
与我相关
我的任务
分享
if exists( select * from sys.triggers where name='update_trigger')
drop trigger update_trigger
go
create trigger update_trigger
on Student
for update
as begin
if update(Sno)
begin
--需要填写的SQL语句,随着Student的跟新Student_log也跟新
end
end
if exists( select * from sys.triggers where name='update_trigger')
drop trigger update_trigger
go
create trigger update_trigger
on Student
for update
as begin
if update(Sno)
begin
--需要填写的SQL语句,随着Student的跟新Student_log也跟新
update Student_log
set Student_log.Sno=i.Sno
from inserted i,deleted d
where Student_log.Sno=d.Sno
end
end