create trigger trigger_name
after update on data_order_status
AS
begin
insert into aud_data_order_status(logname,logtime,action,machine,program,status_old,status)
select
sys_context('USERENV','OS_USER'),
sysdate,
’update’,
sys_context('USERENV','HOST'),
program,
status_old =(select status from deleted),
status =(select status from inserted)
END;
after update on data_order_status
AS
begin
insert into aud_data_order_status(logname,logtime,action,machine,program,status_old,status)
select
sys_context('USERENV','OS_USER'),
sysdate,
’update’,
sys_context('USERENV','HOST'),
program,
status_old =(select status from deleted),
status =(select status from inserted)
END;
解决方案 »
- SQL server怎样使用ALTER 语句修改字段名
- 急切!谢谢各位以前帮助!我如何跟踪SQL SERVER的SQL语句?
- 请问procedure返回值的意思
- SQL server 2000个人版启动问题?
- Why did my sqlcmd -L output nothing?
- [高分求解-顶者有分]如何把行转换成列?
- 求百万数据的sql server高性能分页sql语句
- ACCESS 在文本型字段中,找出最大的数字!
- sql server 2005安装问题
- 如何在不同ip段上用执行sql脚本来保持两个表数据同步?
- 一个表上的多个触发器执行顺序问题 在线等。。。。。。。。。。。。。。。。。。。。。。。
- 非常复杂的交叉表查询,请各位老大帮忙看看。给100分
after update on data_order_status
AS
begin
insert into aud_data_order_status(logname,logtime,action,machine,status_old,status)
select
user,
convert(varchar,getdate()),
'update’,
host_name(),
D.status_old,
I.status
from deleted D join inserted I on D.主键=I.主键
END
after update on data_order_status
AS
insert into aud_data_order_status(logname,logtime,action,machine,program,status_old,status)
select
user,
sysdate,
'update',
host_name(),
program,
status_old =(select status from deleted),
status =(select status from inserted)
GO
after update on data_order_status
AS
insert into aud_data_order_status(logname,logtime,action,machine,program,status_old,status)
select
user,
getdate(),
'update',
host_name(),
program,
status_old =(select status from deleted),
status =(select status from inserted)
GO
1.user能不能显示网络登陆的用户名,而不是数据库的用户名
2.以上的program出错.
有没有办法解决,谢谢啦!