有哪位大虾知道sp_prepexec存储过程是做什么用的吗?

有哪位大虾知道sp_prepexec存储过程是做什么用的吗?SQLServer的帮助里找不到呀!
---------------------------------------------------------------

When you use EXEC statement, behind the scenes, three system internal stored procedures: sp_prepexec, sp_execute, and sp_unprepare are called

From the name, you can tell that sp_prepexec is used to prepare dynamic SQL on the server, which speeds up subsequent executions of the same statement

Published At
Categories with 数据库类
comments powered by Disqus