1. The storage process procedure is a set of collection of SQL statements in order to accomplish a specific function, compiled after stored in the database, the user by specifying the name of the stored procedure and parameters is given to perform,
2. A stored procedure can contain logic control statements and data manipulation statements, it can accept parameters, output parameters, and returns a single result set and returns a value too much,
3. Due to the stored procedure on the database server in the create compiled and stored in the database, so is faster than a single SQL statement block, invoked only need a stored procedure, the parameters of all kinds of necessary information,

Advantages:
1. The stored procedure created can be called multiple times in a program, can also be modified, will not affect the program code, portability,
2. The system administrator can to perform a stored procedure access restrictions, which can realize to some data access restrictions, avoid unauthorized users access to data, ensure the security of the data,

CodePudding user response:

So I send you a post mean to the popular science

CodePudding user response:

Popular science post!!!!!!!!!!!!!!

CodePudding user response:

You are asking the answer