Sql Stored Procedure

2010 2nd International Conference on Education Technology and Computer (ICETC)

Dynamically Maintain The Teaching Examples of Triggers and Stored Procedures about The Course of Database Application

WuDa-sheng

School of Information Engineering Zhejiang Forestry University Lin'an 3113OO,Zhejiang, China e-mail: wu62390710@263.net

Wu Sheng-yu

Hangzhou ZhiYuan Electrical Co., Ltd. Hangzhou 310013 e-mail: wsyll14@163.com

Abstract-Triggers

and

stored

procedures

have

an

irreplaceable importance in the teaching process about the course of database application, as them can realized a complex program logic and can test student's comprehensive application ability to SQL languages. At present, all kinds of management platforms of DBMS (such as the Enterprise Management) are still some inconvenient aspects: when the users want to input the description information of triggers and stored procedure, Enterprise Management appeared to be inadequate; when users want to track the modified-process of triggers and stored procedures, feature; in particular, EM EM did not provide such a manages to triggers with

by user, so that it execute faste than a single SQL statement[1,5,6]. Trigger is a special kind of stored procedure, the trigger will become effective when data is modified using the following one or more data modification operations in the specified table: UPDATE, INSERT, or DELETE. The trigger has the following advantages: Triggers are self­ executing, they were activated immediately after the data were changed on the table; the associated table can be related updated in the database through the triggers; triggers can enforce restrictions which are more complex than CHECK constraints, and compared with the check constraints, the triggers can reference columns from other tables[2,3,4]. Triggers and stored procedures can contain variables defined, cursors, statement's block which is composed of the data defmition language, data manipulation language,...