SQLServer触发器创建、删除、修改、查看(2)

设置字体: 大中小

----------------------------------

print ' no entry in goods for this order'
rollback transaction
end

6：Orders表建立一个插入触发器，保证向Orders表插入的货品信息要在Order表中添加

alter trigger addOrder
on Orders
for insert
as
insert into Order
select inserted.Id, inserted.goodName,inserted.Number from inserted

----------------------------------

课程列表

重点难点