CREATE trigger ins_user_trigger on [user] for insert as insert b.dbo.user1 select username,userpassword from inserted
CREATE trigger ins_user_trigger on [user] for insert as insert b.dbo.user1 (username,userpassword) select username,userpassword from inserted
use acreate trigger insert_user on user for insert,update as if update(password) or update(username) update b..user set username=u.username,password=u.password from b..user b,updated u on b.id=u.id else update b..user set username=i.username,password=i.password from b..user b,inserted i on b.id=i.id
CREATE TRIGGER 名1 ON dbo.[user] FOR INSERT AS insert b.dbo.user1 select username,userpassword from insertedCREATE TRIGGER 名2 ON dbo.[user] FOR update AS update b.dbo.user1 set 列=aa.列 from inserted aa where aa.编号=b.dbo.user1.编号 CREATE TRIGGER 名3 ON dbo.[user] FOR delete AS delete b.dbo.user1 where 编号 in (select 编号 from deleted)
select * from a..user
on [user]
for insert
as
insert b.dbo.user1 select username,userpassword from inserted
on [user]
for insert
as
insert b.dbo.user1 (username,userpassword)
select username,userpassword from inserted
for insert,update
as
if update(password) or update(username)
update b..user set username=u.username,password=u.password from b..user b,updated u on b.id=u.id
else
update b..user set username=i.username,password=i.password from b..user b,inserted i on b.id=i.id
CREATE TRIGGER 名1 ON dbo.[user]
FOR INSERT
AS
insert b.dbo.user1 select username,userpassword from insertedCREATE TRIGGER 名2 ON dbo.[user]
FOR update
AS
update b.dbo.user1 set 列=aa.列
from inserted aa where aa.编号=b.dbo.user1.编号
CREATE TRIGGER 名3 ON dbo.[user]
FOR delete
AS
delete b.dbo.user1 where 编号 in (select 编号 from deleted)
select * from a..user
最好