create trigger tri_kp01 (触发器名)
on fs_kp01(表名)
for insert
as
begin
declare @a varchar(20),@b varchar(20);
select @a = id1,@b= pjh from inserted; -- 把新增的值赋值给变量
insert into fs_insert values(@a,@b);
end
create trigger tri_kp01 (触发器名)
on fs_kp01(表名)
for insert
as
begin
declare @a varchar(20),@b varchar(20);
select @a = id1,@b= pjh from inserted; -- 把新增的值赋值给变量
insert into fs_insert values(@a,@b);
end