Question

在a数据库中的book表上创建一个触发器，使得无论何时向book表中插入一条记录，

都将更新bookEnrol表中的dependdate列

Answer 1

bookEnrol表与book表有关系吗，更新是全部更新还是依条件更新？
可用类似如下方法来创建触发器。

create trigger tri_update_dependdate on book for insert
as
begin
if exists(select * from inserted)
begin
update bookEnrol set dependdate = getdate()
end
end

Answer 2

CREATE TRIGGER [dbo].[Tri_Book_UpdateDependdate] ON BOOK
AFTER INSERT
AS
BEGIN
IF Not Exists(Select 1 From Deleted)
Begin
Update BE
Set BE.dependdate=?
From bookEnrol BE,Inserted I
Where ?
End
END

Answer 3

可以在 before insert 操作