存储过程与触发器在数据库开发中的应用

Application of stored procedures and trigger to development of database system

存储过程和触发器都是存储在数据库中的一段程序,应用程序可以调用存储过程来执行某种操作。使用触发器可以完成复杂的规则检查,使用存储过程可以将前台程序的设计和后台程序的设计分开,减少系统设计的复杂性。阐述了存储过程和触发器的创建方法,同时说明了VB和ASP调用存储过程的方法。

Both stored-procedure and trigger are a segment of executable code in the database. It can be called by an application process. Using the trigger the application system can perform a complex rule check and using the storedprocedure the design of the application system can be divided into two sections-the foreground program and the background one. That can reduce the complexity of the system design. The methods of creating a stored procedure and a trigger and the ways of calling a stored procedure in VB and ASP are described.