A stored procedure can be seen as one or more SQL commands that already reside at the database server, prepared and ready to be executed.
存储过程可以被视为一条或多条已驻留在数据库服务器中、准备好执行的SQL命令。
Because a stored procedure is compiled on the server when it is created, it executes faster than individual SQL statements.
由于存储过程是在创建时便在服务器上编译了，因此它比单个sql语句执行得更快。
Below is an example of a Stored Procedure for Microsoft SQL Server 2005.
下面是一个针对Microsoft SQL Server 2005的示例存储过程。
应用推荐