create trigger 名 on A
for insert
as
insert B (username,userpass) Select username,userpass from inserted
insert C (username,userpass) Select username,userpass from inserted
insert D (username,userpass) Select username,userpass from inserted
insert E (username,userpass) Select username,userpass from inserted
for insert
as
insert B (username,userpass) Select username,userpass from inserted
insert C (username,userpass) Select username,userpass from inserted
insert D (username,userpass) Select username,userpass from inserted
insert E (username,userpass) Select username,userpass from inserted
as
insert into b (username) select username from inserted
insert into c (username) select username from inserted
insert into d (username) select username from inserted
insert into e (username) select username from inserted
ON A
FOR INSERT
AS
declare @username varchar(10) ,@userpass varchar(10)BEGIN
begin transaction
select @username=username,@userpass=userpass from inserted
insert B (username,userpass) values (@username,@userpass)
insert C (username,userpass) values (@username,@userpass)
insert D (username,userpass) values (@username,@userpass)
insert E (username,userpass) values (@username,@userpass)
commit transactionEND
for insert
as
insert into B(name) select name from inserted
insert into C(name) select name from inserted
insert into D(name) select name from inserted
insert into E(name) select name from inserted
go