22,210
社区成员
发帖
与我相关
我的任务
分享
ALTER TRIGGER [ST].TRIG_TABLE1_LOG_INSERT
ON [ST].TABLE1_TMP
AFTER INSERT
AS
BEGIN
declare @spid varchar(32)
set @spid = (select @@spid)
SET NOCOUNT ON;
insert into TAB_LOG
(
HOST_NAME,
NET_ADDRESS,
LOGIN_NAME,
LOGIN_TIME,
TABLE_NAME,
OPERATE_TPYE
)
SELECT NET_ADDRESS,LOGIN_NAME,LOGIN_TIME,TABLE_NAME,OPERATE_TPYE,'[ST].TABLE1_TMP,INSERT'
FROM master..sysprocesses where spid = @spid
END
出了点小意外
--批量处理不能你这样
ALTER TRIGGER [ST].TRIG_TABLE1_LOG_INSERT
ON [ST].TABLE1_TMP
AFTER INSERT
AS
BEGIN
declare @spid varchar(32)
set @spid = (select @@spid)
SET NOCOUNT ON;
insert into TAB_LOG
(
HOST_NAME,
NET_ADDRESS,
LOGIN_NAME,
LOGIN_TIME,
TABLE_NAME,
OPERATE_TPYE
)
SELECT NET_ADDRESS,LOGIN_NAME,LOGIN_TIME,TABLE_NAME,OPERATE_TPYE,'[ST].TABLE1_TMP,'INSERT'
FROM master..sysprocesses where spid = @spid
END
GO