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

触发器、存储过程和函数三者有何区别（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