Shulou(Shulou.com)06/01 Report--

SQL trigger is a special type of stored procedure. This is special because it is not called directly like a stored procedure. The main difference between a trigger and a stored procedure is that when a data modification event is performed on a table, the trigger is automatically called, while the stored procedure must be explicitly called. 1. The advantages of SQL triggers SQL triggers provide an alternative way to check data integrity. SQL triggers can catch errors in the business logic in the database layer. SQL triggers provide another way to run scheduled tasks. By using SQL triggers, you do not have to wait for the scheduled task to run, because triggers are automatically invoked before or after making changes to the data in the table. SQL triggers are useful for auditing changes to data in a table. 2. Disadvantages of SQL triggers SQL triggers can only provide extended validation and cannot replace all validations. Some simple verification must be done at the application layer. For example, you can use JavaScript or server-side scripting languages (such as JSP,PHP,ASP.NET,Perl, etc.) to validate client-side user input. Calling and executing SQL triggers from the client application are not visible, so it is difficult to figure out what is happening in the database layer. SQL triggers may increase the overhead of the database server. The article is from www.huthon.cn.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.