摘要
SQL Server数据库是当今有代表性的大型网络数据库之一,存储过程(Stored Procedure)是一组为了完成特定功能的SQL语句集,经编译后存储在数据库中,可以作为一个单元被用户的应用程序直接调用。触发器是一种特殊类型的存储过程,主要是通过事件进行触发自动执行。笔者在开发了大宗商品现货电子撮合交易系统的基础上,总结了存储过程和触发器的基本概念及具体应用,展现了其在数据库开发中强大功能和使用特点。
SQL Server database is one of today＇s representative of a large network database stored procedure （Stored Procedure） is a set of SQL statements in order to accomplish a specific function set,stored in the database is compiled as a unit by the user invoked directly by applications.The trigger is a special type of stored procedure,trigger automated event.On the basis of developed commodity spot electronic matching trading system,the author summarizes the basic concepts and specific applications of stored procedures and triggers,and demonstrated its powerful database development and use characteristics.
出处
《计算机光盘软件与应用》
2012年第1期66-66,71,共2页
Computer CD Software and Application
