创建了一个触发器实现对表进行增加删除修改的记录。
代码如下:
USE [Huahai1966]
GO
/****** Object: Trigger [dbo].[tr_receipt] Script Date: 2019/6/14 15:37:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER trigger [dbo].[tr_receipt]
on [dbo].[T_In_Receipt] after insert
as
begin
DECLARE
@op nvarchar(10),
@operator VARCHAR(255),
@optime VARCHAR(255),
@info NVARCHAR(255),
@in_code NVARCHAR(50)
SET @op='插入'
SELECT @operator= inserted.C_CreateBy,
@optime= inserted.C_CreateTime,
@in_code = inserted.C_Code,
@operator= inserted.C_CreateBy FROM inserted
SET @info = N'入库单于' + @optime + '执行了' + @op + '操作, '+ '编号:'+ @in_code +', 操作人:'+ @operator
INSERT INTO dbo.Log_In
(
operation,
operator,
op_time,
info
)
VALUES
( @op, -- operation - nvarchar(50)
@operator, -- operator - nvarchar(50)
@optime, -- op_time - datetime
@info -- info - nvarchar(50)
)
end
但是在operator op-time info 等字段一直无法传值过去 总是空 哪位大神能帮个忙?