触发器、存储过程和函数三者有何区别（Triggers, stored procedures and functions. What is the difference between the three）.doc

触发器、存储过程和函数三者有何区别（Triggers, stored procedures and functions. What is the difference between the three） What time for a stored procedure? The storage process procedures, it is through grammar check and compile the SQL statement, so run very fast. Trigger is a special process of storage, storage process and trigger program calls will automatically execute the function; what you say is a custom function, the function is to produce output according to the input, custom only input-output relationship defined by the user. At what time the trigger is used? According to the requirements of the system operation automatically according to the number of input tasks, for example, buy out of the product automatically deduct the inventory of the product. What time for a stored procedure? The storage process procedures, it is through grammar check and compile the SQL statement, so run very fast. The difference between stored procedures and user-defined function specific Look at the definition of: stored procedure The stored procedure can make the management of database, and the display of database and user information much easier. The stored procedure is SQL statements and optional control flow statements precompiled collection stored under a name and processed as a unit. Stored in the database, the application by a call, and allows the user to declare variables, conditional execution, and other powerful programming function. The stored procedure can include program flow, logic and queries to a database. They can accept parameters, output parameters, return a single or multiple result sets and return value. You can use the stored procedure for any use of the SQL statement, it has the following advantages: Can perform a series of SQL statements in a single storage process. Can refer to other stored procedures from their stored procedures, which can simplify a series of complex statements. In the process of creating storage on the server is compiled, so to implement than a single SQ