create trriger tr_a on table_a
for insert
as
begin
insert into table_b (b_a_id,b_a_title) select a_id,a_title from inserted
insert into table_c(c_a_id,c_a_content) select a_id,a_content from inserted
end
for insert
as
begin
insert into table_b (b_a_id,b_a_title) select a_id,a_title from inserted
insert into table_c(c_a_id,c_a_content) select a_id,a_content from inserted
end
========================================
create table a (
id int identity(1,1),
name varchar(10),
s text)
create table b (
id int identity(1,1),
name varchar(10),
s text)
go
create trigger tr_a on a
for insert
as
begin
declare @id int
declare @name varchar(10)
declare @ptr_src binary(16)
declare @ptr_des binary(16)insert b(name,s) select name,'' from insertedselect @ptr_src = textptr(a.s) from a,inserted where a.id = inserted.id
select @ptr_des = textptr(b.s) from b,inserted where b.name = inserted.nameupdatetext b.s @ptr_des 0 0 a.s @ptr_srcend
go
insert a(name,s)
select 'nnn','sss'select * from a
select * from bdrop table a
drop table b