摘要
随着社会信息化水平的不断提高,越来越多的银行使用MIS(管理信息系统)进行报表管理,而在大多数的MIS系统中经常用到存储过程和触发器。文章在分析存储过程和触发器的诸多优势基础上,介绍了它们的使用方法,最后结合一个实际的银行报表管理系统,给出了部分存储过程和触发器的实现源代码。
With the continuous raising of the level of social informatization,more and more banks manage their statements and reports by using the Management Information System(MIS),and most of such systems often use the store procedure and trigger. The advantages of the store procedure and trigger are introduced,and the way of how to use them is described. A part of the source code is provided based on the analysis of an actual management system of bank statements and reports.
出处
《合肥工业大学学报(自然科学版)》
CAS
CSCD
2004年第3期278-281,共4页
Journal of Hefei University of Technology:Natural Science
关键词
存储过程
触发器
银行报表管理系统
store procedure
trigger
management system of bank statements and reports