MS SQL DE inserted,deleted,updated durumu öğrenme trigerde

 

/******************************/

 exists (select * from inserted) and exists (select * from deleted)

select  @AuditType= 'U'

else if exists (select * from inserted)

select  @AuditType= 'I'

else

select  @AuditType = 'D'

/******************************/

/******************************/

if exists (select * from inserted) 

if exists (select * from deleted) 

SET @AuditType = 'U' 

else 

SET @AuditType = 'I' 

else 

SET @AuditType = 'D'

/******************************/