一个小小的触发器的问题

Question

create trigger tr
on 表
for insert,update,delete
as
insert Logs(日期时间,操作员,日志内容)
select getdate(),
       user,
       (
         case when not exists(select 1 from inserted)
              then '删除了纪录'+(select top 1 字段 from deleted)
              when not exists(select 1 from deleted)
              then '插入了纪录'+(select top 1 字段 from inserted)
              else
              '更新了纪录'+(select top 1 字段 from inserted)
         end
       )

Answer 1

to vivianfdlpw() 请问一下 这个user 是怎么确定的

Answer 2

create trigger insert_update_deletelog
on 表名1
for update,insert,delete
as
 insert into 表名2
         (字段1,
         字段2,
         字段3,
         字段4 ,
         .
         .
         user,
         updatetime)
select
         字段1,
         字段2,
         字段3,
         字段4 ,
         .
         .
         current_user,
         current_time_stamp
form updated