sybase创建触发器记录ip

人去楼空都成过往

于 2022-04-18 15:59:52 发布

阅读量377

点赞数 1

分类专栏：数据库文章标签：数据库

本文链接：https://blog.csdn.net/qq_42042615/article/details/124251868

版权

数据库专栏收录该内容

2 篇文章 0 订阅

订阅专栏

create trigger TRIGGER_T_USER on T_USER
for insert, update as
declare 
@ipaddr varchar(20),
@yhdm varchar(20),
@yhxm varchar(20),
@yhkl varchar(20),
@jmkl varchar(32),
@md5 varchar(32),
@zxrybs int,
@zxrybs1 int,
@bs1 int,
@bs int,
@hostName varchar(50)
select @yhdm = YHDM from inserted
select @yhxm = YHXM from inserted
select @yhkl = YHKL from inserted
select @jmkl = JMKL from inserted
select @md5 = MD5 from inserted
select @bs = BS from inserted
select @zxrybs = ZXRYBS from inserted
select @bs1 = BS from deleted
select @zxrybs1 = ZXRYBS from deleted
begin
select @hostName=hostname,@ipaddr=ipaddr from master..sysprocesses where spid=@@spid
INSERT INTO T_USER_LOGS(YHDM,YHXM,YHKL,JMKL,MD5,BS,BS1,ZXRYBS,ZXRYBS1,V_CLIENTIP,HOSTNAME,LASTUPDATE) VALUES(@yhdm,@yhxm,@yhkl,@jmkl,@md5,@bs1,@bs,@zxrybs1,@zxrybs,@ipaddr,@hostName,getdate())
end