create trigger tri_name on a for update as begin insert into b(a,b,c) select a,b,c from deleted --插入被修改前的数据 insert into b(a,b,c) select a,b,c from inserted--插入被修改后的新数据 end
??? create trigger trg on A for update as insert b select filed1,filed2 from deleted
create trigger AA on A for update begin insert into B select * from deleted insert into b select * from inserted end
create trigger tri_name on a for update as begin insert into b(a,b,c) select a,b,c from deleted --插入被修改前的数据 insert into b(a,b,c) select a,b,c from inserted--插入被修改后的新数据 endupdate 表 set 姓名2=姓名
on a
for update
as
begin
insert into b(a,b,c) select a,b,c from deleted --插入被修改前的数据
insert into b(a,b,c) select a,b,c from inserted--插入被修改后的新数据
end
create trigger trg
on A
for update
as
insert b select filed1,filed2 from deleted
假如 姓名1 姓名2 年龄 职业
小王 NULL 21 技工
小陈 NULL 23 技工
小明 NULL 45 技工
小张 NULL 65 技工
.....我想修改 姓名2 的字段跟姓名1的对应起来 如何修改,请教了~!
数据有还几百条的情况下.谢谢
for update
begin
insert into B select * from deleted
insert into b select * from inserted
end
on a
for update
as
begin
insert into b(a,b,c) select a,b,c from deleted --插入被修改前的数据
insert into b(a,b,c) select a,b,c from inserted--插入被修改后的新数据
endupdate 表 set 姓名2=姓名