create trigger t1 on table1 for insert as update table1 set b = a from inserted where table1.id = inserted.id
create trigger t1 on table1 for insert as update table1 set b = a from inserted where table1.a = inserted.a
create trigger t1 on table1 for insert as update table1 set b = a+100 from inserted where table1.a = inserted.a
--create table a(CategoryID int identity(1,1),name char(20) null, SubCategory char(10)) --insert into a (name) values('sub11') --insert into a (name) values('sub12') --insert into a (name) values('sub13') --insert into a (name) values('sub14') --insert into a (name) values('sub21') --insert into a (name) values('sub22') go create trigger t1 on a instead of insert as begin insert into a (name,SubCategory) select name,cast(CategoryID as char(10))+'wofengle' from inserted end --select * from a --insert into a (name) values('sub23') --drop trigger t1
--create table a(CategoryID int identity(1,1),name char(20) null, SubCategory char(10)) --insert into a (name) values('sub11') --insert into a (name) values('sub12') --insert into a (name) values('sub13') --insert into a (name) values('sub14') --insert into a (name) values('sub21') --insert into a (name) values('sub22') go create trigger t1 on a instead of insert as begin insert into a (name,SubCategory) select name,cast(CategoryID as char(10))+'wofengle' from inserted end --select * from a --insert into a (name) values('sub23') --drop trigger t1 但执行时有问题,还望大侠们多多指点
CREATE TRIGGER yourTriggerName on yourTable For INSERT AS BEGIN Update B set yourField = newValue From B join Inserted on B.KeyField = Inserted.KeyField END
create trigger trig_table1_insert on table1 for insert as update table1 set b = a from inserted where table1.a = inserted.a
for insert
as
update table1 set b = a from inserted where table1.id = inserted.id
for insert
as
update table1 set b = a from inserted where table1.a = inserted.a
for insert
as
update table1 set b = a+100 from inserted where table1.a = inserted.a
--insert into a (name) values('sub11')
--insert into a (name) values('sub12')
--insert into a (name) values('sub13')
--insert into a (name) values('sub14')
--insert into a (name) values('sub21')
--insert into a (name) values('sub22')
go
create trigger t1 on a
instead of insert
as
begin
insert into a (name,SubCategory) select name,cast(CategoryID as char(10))+'wofengle' from inserted
end
--select * from a
--insert into a (name) values('sub23')
--drop trigger t1
--insert into a (name) values('sub11')
--insert into a (name) values('sub12')
--insert into a (name) values('sub13')
--insert into a (name) values('sub14')
--insert into a (name) values('sub21')
--insert into a (name) values('sub22')
go
create trigger t1 on a
instead of insert
as
begin
insert into a (name,SubCategory) select name,cast(CategoryID as char(10))+'wofengle' from inserted
end
--select * from a
--insert into a (name) values('sub23')
--drop trigger t1
但执行时有问题,还望大侠们多多指点
For INSERT
AS
BEGIN
Update B set yourField = newValue From B join Inserted on B.KeyField = Inserted.KeyField
END
for insert
as
update table1 set b = a from inserted where table1.a = inserted.a