- Learn T-SQL Querying
- Pedro Lopes Pam Lahoud
- 168字
- 2021-06-24 14:38:13
The sp_executesql procedure
The sp_executesql procedure is the recommended method for sending an ad hoc T-SQL statement to SQL Server. If stored procedures cannot be leveraged for some reason, such as when T-SQL statements must be constructed dynamically by the application, sp_executesql allows the user to send an ad hoc T-SQL statement as a parameterized query, which uses a similar caching mechanism to stored procedures. This ensures that the plan can be reused whenever the same query is executed again. Building on our example from the Ad hoc plan caching section, we can rewrite the query using sp_executesql, as in the following example which can be executed in the AdventureWorks sample database:
EXECUTE sp_executesql @stmt = N'SELECT LastName, FirstName, MiddleName
FROM Person.Person
WHERE PersonType = @PersonType;'
, @params = N'@PersonType nchar(2)'
, @PersonType = N'EM';
This ensures that any time the same query is sent with the same parameter markers, the plan will be reused, even if the statement is dynamically generated by the application.
- Hands-On Intelligent Agents with OpenAI Gym
- 計算機圖形學
- 并行數據挖掘及性能優化:關聯規則與數據相關性分析
- Expert AWS Development
- 人工智能工程化:應用落地與中臺構建
- CentOS 8 Essentials
- CompTIA Linux+ Certification Guide
- Deep Reinforcement Learning Hands-On
- 基于Xilinx ISE的FPAG/CPLD設計與應用
- Spatial Analytics with ArcGIS
- INSTANT Puppet 3 Starter
- Visual Studio 2010 (C#) Windows數據庫項目開發
- 網絡脆弱性掃描產品原理及應用
- 計算機應用基礎實訓(職業模塊)
- Hands-On Business Intelligence with Qlik Sense