create trigger remark_time
on remark
instead of insert
as
begin transaction
begin
declare @remarkid int,@novelid int,@userid int ,@con nvarchar(500)
select @remarkid= remark_id from inserted
select @novelid= novel_id from inserted
select @userid= user_id from inserted
select @con= content from inserted
insert
into
online_novel.dbo.remark
(content, novel_id, remark_time, user_id, remark_id)
values
(@con, @novelid, GETDATE(), @userid, @remarkid)
end
commit transaction
这样这里面的remarktime 就可以自动插入到数据库中啦