What is an ASP stored procedure

Always hear people say how good stored procedures, how to have advantages, really want to study this thing. Although now is still the study stage, first take out to share.

Always hear people say how good stored procedures, how to have advantages, really want to study this thing.

Although now is still the study stage, first take out to share.

Generally speaking, you can put a lot of SQL statements in the stored procedures, and then, using ASP to execute the stored procedures on it.
Using ASP to execute a stored procedure, so that those statements in the MSSQL library execution, far more than through the ASP to execute a lot of SQL efficiency is much higher.

Examples are shown below:

ASP execution >> stored procedure >>mssql Internal Processing multi-sentence SQL statement operation table
ASP executes >>SQL statement >> action Sheet

If there are complex SQL statement operations, the former efficiency is much higher.