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.
下面是一个针对MicrosoftSQL Server 2005的示例存储过程。
The stored procedure is compiled on the server when it is created, so it executes faster than individual SQL statements.
存储过程于创建时在服务器上进行编译,所以执行起来比单个SQL 语句快。
The main way: password loophole attack, SQL Server extended stored procedure attack, SQL Injection (SQL Injection), steals backup, etc.
主要手法有:口令漏洞攻击、SQL Server扩展存储过程攻击、SQL注入(SQLInjection)、窃取备份等。
The main way: password loophole attack, SQL Server extended stored procedure attack, SQL Injection (SQL Injection), steals backup, etc.
主要手法有:口令漏洞攻击、SQL Server扩展存储过程攻击、SQL注入(SQLInjection)、窃取备份等。
应用推荐