SQL简单触发器操作

通过使用这两个触发器，少写了很多代码，并且在性能和安全性方面都得到了一定的提高。看来以后要多使用触发器。

CREATE TRIGGER T_TitleUpdate ON PE_Contacter
FOR INSERT
AS
begin
 DECLARE @userName varchar(50)
 select @userName=userName from inserted
 update PE_Contacter set Title=TrueName where UserName=@userName
 update PE_Contacter set trueName='' where UserName=@userName
end

CREATE TRIGGER T_AdminRegister ON  PE_Users
FOR INSERT
AS
begin
 DECLARE @adminID INT,@adminPassword varchar(50),@userName varchar(50),@trueName varchar(50)
 select @adminID=MAX(adminID) +1  from PE_ADMIN
 select @adminPassword=userPassword,@userName=userName,@trueName=trueName from inserted

 insert into PE_Admin(AdminID,AdminName,AdminPassword,UserName,EnableMultiLogin) values(@adminID,@userName,@adminPassword,@userName,1)
 insert into PE_Admin_Roles values(@adminID,4)
end