CREATE TRIGGER UserABTableInsert ON A.form1 '添加
FOR INSERT
AS
declare @username nvarchar(255)
@username=select username from inserted
insert into B.form2 select * from A.form1 where username=@username
CREATE TRIGGER UserABTableInsert ON A.form1 '删除
FOR DELETE
AS
declare @username nvarchar(255)
@username=select username from deleted
delete from B.form2 where Name=@username
CREATE TRIGGER UserABTableInsert ON A.form1 '修改
FOR UPDATE
AS
declare @oldname nvarchar(255),@username nvarchar(255),@password nvarchar(255),@fullname nvarchar(255)
@oldname=select username from deleted
@username=select username from inserted
@password=select password from inserted
@fullname=select fullname from inserted
update B.form2 set Name=@username,pd=@password,fname=@fullname where username=@oldname
FOR INSERT
AS
declare @username nvarchar(255)
@username=select username from inserted
insert into B.form2 select * from A.form1 where username=@username
CREATE TRIGGER UserABTableInsert ON A.form1 '删除
FOR DELETE
AS
declare @username nvarchar(255)
@username=select username from deleted
delete from B.form2 where Name=@username
CREATE TRIGGER UserABTableInsert ON A.form1 '修改
FOR UPDATE
AS
declare @oldname nvarchar(255),@username nvarchar(255),@password nvarchar(255),@fullname nvarchar(255)
@oldname=select username from deleted
@username=select username from inserted
@password=select password from inserted
@fullname=select fullname from inserted
update B.form2 set Name=@username,pd=@password,fname=@fullname where username=@oldname