如何判断是在何种情况下触发触发器

Question

1:
  if not exists(Select * from deleted)
     print 'insert'
  else
  begin
  if not exists(select * from inserted)
    print 'delete'
  else
    print 'update'
  end

Answer 1

eg: select pwdencrypt('123456')

Answer 2

这里有几个热心同志自己写的加密函数
http://expert.csdn.net/Expert/topic/2343/2343722.xml?temp=.6119348

Answer 3

create trigger t_test on 表
for insert,update,delete
as
  if exists(Select 1 from deleted)
  if exists(select 1 from inserted)
     print '修改'
  else
     print '删除'
  else 
    print '新增'
go