增加
CREATE TRIGGER [dbo].[user_Insert]
ON [dbo].[t_Users]
AFTER Insert
AS
BEGIN
SET NOCOUNT ON;
insert into users2 (uid,cname,mobile_no,pwd) select username,name,mobile,pwd from inserted
END
更新
CREATE TRIGGER [dbo].[zsusers_Update]
ON [dbo].[users1]
AFTER UPDATE
AS
If UPDATE(lxr)
BEGIN
SET NOCOUNT ON;
update a set lxr=b.lxr,mobile_no=b.mobile_no,tel=b.tel,email=b.email,qq=b.qq,fax=b.fax,curl=b.curl,zip=b.zip,addr=b.addr
from users2 a join inserted b on a.uid=b.username
END
if UPDATE(vip)
Begin
Set NoCount ON;
update a set vip=b.vip,viplevel=b.viplevel from users2 a join inserted b on a.uid=b.username
End