7.tr_deleteloginuser.sql

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

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

CREATE TRIGGER tr_deleteloginuser ON [dbo].[f_loginuser] 
FOR DELETE 
AS
Begin 
 Declare @intRowcount int
 
 Select  @intRowcount = @@Rowcount
 if @intRowcount > 0 
 Begin
  delete f_accredit Where c_loginuserid in (Select c_loginuserid from deleted) 
  delete f_corpaccredit Where c_loginuserid in (Select c_loginuserid from deleted) 
 End
End