Database storage process and trigger Mixing

The stored procedure is reusable.CodeModule to efficiently complete specified operations.

You can also use the CLR method to write stored procedures in the transact-SQL language.
1. There are three types of stored procedures: User-Defined stored procedures, extended stored procedures, and system storage.

Process
Syntax for creating a stored procedure:
Create procedure procedure_name
Parameter_name data_type ,...
With procedure_option
As
SQL _statement
You can use the execute statement to execute the stored procedure. The alter procedure statement already exists.

.
2. A trigger is a special type of stored procedure, which includes a large number of transact-SQL statements.

There are two types: DML triggers and DDL triggers.
DML is divided into three types based on the trigger event types: insert, update, and delete.
DDL trigger events include create, alter, drop, Grant, deny,

Revoke and other statements, and the trigger time condition is only after, without instead.
Generally, DDL triggers are mainly used for the following operations:
Prevents some changes to the database architecture.
You want a situation in the database to make changes in the corresponding database architecture.
Records changes or events in the database architecture.