8.tr_insert_loginuser.sql

学习PB入门的好帮手,附件中包含以下文件夹

if exists (select 1 from sysobjects where id = object_id('tr_insert_loginuser'))
   drop trigger tr_insert_loginuser
go


CREATE TRIGGER tr_insert_loginuser ON [dbo].[f_loginuser] 
FOR INSERT
AS
Begin 
 Declare @iAdmin int
 Declare @sID char(36)
 
 Select  @sID = c_loginuserid,@iAdmin = i_admin from inserted
 if @iAdmin = 0
 Begin
    insert into f_accredit values(@sID,'403')
 End
 if @iAdmin = 1
 Begin
    insert into f_accredit values(@sID,'401')
    insert into f_accredit values(@sID,'402')
    insert into f_accredit values(@sID,'403')
 End
End