Application of Stored Procedures and Triggers in Supermarket Management System
孙振华1
扫码查看
点击上方二维码区域，可以放大扫码查看
作者信息
1. 江苏联合职业技术学院镇江分院信息系,江苏镇江 212016
折叠
摘要
存储过程和触发器是数据库中的重要编程对象,在系统设计中可以提升数据库的性能.触发器是一种特殊的存储过程,主要用于实现比约束更复杂的功能,维护数据的完整性.文章利用SQL Server 2019数据库管理工具,以商超管理系统为例,研究存储过程和触发器在该系统中的应用,并结合实际案例,给出了存储过程和触发器在解决具体业务问题中的实现方法.
Abstract
Stored procedures and triggers are important programming objects in databases,which can improve database performance in system design.Triggers are a special type of stored procedure primarily used to implement more complex functions than constraints and maintain data integrity.The article uses SQL Server 2019 database management tool and takes the supermarket management system as an example to study the application of stored procedures and triggers in the system.Combined with practical cases,it provides the implementation method of stored procedures and triggers in solving specific business problems.
关键词
存储过程/触发器/SQL/Server/商超管理系统
Key words
stored procedures/trigger/SQL Server/supermarket management system
维普
万方数据