数据库创建网上书店语句总结(19)

通过SQL语句创建网上书店的经典语句,同时涵盖了大部分网络数据库要点重点

select deleted.* from deleted end

对图书表中的某记录进行修改，记录验证修改触发器的功能 update bookinfo set b_price='100' where b_id='tp3/111'

将上面的修改触发器禁用 alter table bookinfo disable trigger tr_book1

为图书表创建删除触发器，实现显示图书表、inserted表和deleted表中记录的功能 create trigger tr_book2 on bookinfo for delete as begin

select bookinfo.* from bookinfo select inserted.* from inserted select deleted.* from deleted end

删除图书表中某条图书记录。验证触发器的执行 delete from bookinfo