摘要:
一、触发器 触发器的两张虚拟表: Tickets表原始数据: TicketsOrders表原始数据: 1.插入触发器 创建: 1 create trigger ticketsOrdersInsert 2 on edisondb..ticketsOrders 3 after insert 4 as 5 begin 6 if (select t.currentAmount from tickets as t,inserted 7 where t.ticketid=inserted.ticketid)< 8 (select amount from inserted) 9 begin10 pri 阅读全文