一段触发器sql语句

[xyzyz]

create trigger book_save
	on borrow
after insert
as
	insert into borrow_save
	(cno,bno,rdate)
	values
	(
	select inserted.cno,inserted.bno,inserted.rdate
	from inserted,books
	where books.bname='数据库技术及应用'
	and inserted.bno=books.bno
	)

做练习的时候，看到的一段触发器的语句，请问各位哪里出错了呢？谢谢了。

[百年树人]

create trigger book_save
    on borrow
after insert
as
    insert into borrow_save
    (cno,bno,rdate)
    select inserted.cno,inserted.bno,inserted.rdate
    from inserted,books
    where books.bname='数据库技术及应用'
    and inserted.bno=books.bno

[htl258_Tony]

create trigger book_save
    on borrow
after insert
as
    insert into borrow_save
    (cno,bno,rdate)
    --values
    (
    select inserted.cno,inserted.bno,inserted.rdate
    from inserted,books
    where books.bname='数据库技术及应用'
    and inserted.bno=books.bno
    )

values多余的.

[Zoezs]

create trigger book_save
    on borrow
after insert
as
    insert into borrow_save
    (cno,bno,rdate)
    select inserted.cno,inserted.bno,inserted.rdate
    from inserted,books
    where books.bname='数据库技术及应用'
    and inserted.bno=books.bno

[百年树人]

insert into tb values(...) 用于插入一条记录

insert into tb (select ... from ta) 用于同时插入多条记录 此时不能带values