trigger ｕｐｄａｔｅ demonstration

if object_id ('stu')is not null drop table stu
go
create table stu(
stu_id int primary key
)
go
if object_id('JS') is not null drop table JS
go
create table JS(
js_id int identity(1,1),
stu_id int ,
JS_time datetime,
HS_time datetime
)

go
insert stu
select 1 union all
select 2 union all
select 3 union all
select 4

go
insert JS(stu_id,JS_time)
select 1,getdate() union all
select 2,getdate() union all
select 3,getdate() union all
select 4,getdate()

go

if exists (select name from sysobjects where name ='update_trigger' and xtype='tr')  drop trigger update_trigger
go
create trigger update_trigger
on stu
for update
as
if update (stu_id)
begin
 update JS set stu_id =i.stu_id from JS j,deleted d,inserted i
 where d.stu_id=j.stu_id        
end

go

update stu set stu_id=10 where stu_id =1

select * from stu
select * from js

 

 

 

support there is two relation table ,when we modify the fist table ,the second table will be modified automatically ~!