增加

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