这两个表触发器如何写

本人也是个菜B...刚看了你的题写了一下这触发器...

首先本人在book_borrowdate列添加了一个default 约束
alter table bookborrow
add constraint df_borrowdate default (getdate) for book_borrowdate

然后就开始写触发器的代码
create trigger maturedate
on bookborrow
after insert
as
update bookborrow
set book_maturedate=(select book_borrowdate from inserted)+
(select bcf.bookborrowday from bookclassinformation bcf
where  bcf.bookclass_id=(select book_isdn from inserted))
where book_isdn=(select book_isdn from bookborrow)

[[italic] 本帖最后由 nhlzh8708 于 2007-12-13 21:05 编辑 [/italic]]