动态SQL的优势 [英] Advantage of Dynamic sql

问题描述

在sql server中使用动态查询的主要优点是什么?

Hi,

What is the main advantage of using dynamic query in sql server?

推荐答案

很显然，您不需要编写具有相同逻辑的查询！
由许多人使用的单个查询会更好.您需要做的就是提供必需的参数以使查询动态化.

问候，
爱德华(Eduard)

Obviously you do not need to write a bunch of query with the same logic!

A single query that is consumed by many would be better. All you need to do is to supply the required parameters to make your query dynamic.

Regards,
Eduard

使用您的朋友google

动态查询在TSQL [

use your friend google

Dynamic Query in TSQL [^]

请阅读以下资源:

http://www.sommarskog.se/dynamic_sql.html [ http://searchdatamanagement.techtarget.com/feature/Static- SQL-vs-dynamic-SQL-for-database-application-performance [

Please read these resources :

http://www.sommarskog.se/dynamic_sql.html[^]

http://searchdatamanagement.techtarget.com/feature/Static-SQL-vs-dynamic-SQL-for-database-application-performance[^]

Hope it helps.

这篇关于动态SQL的优势的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！