动态SQL的优势

本文介绍了动态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 [^]

请阅读以下资源: www.sommarskog.se/dynamic_sql.html [ ^ ] searchdatamanagement.techtarget/feature/Static- SQL-vs-dynamic-SQL-for-database-application-performance [ ^ ] 希望对您有所帮助. Please read these resources : www.sommarskog.se/dynamic_sql.html[^] searchdatamanagement.techtarget/feature/Static-SQL-vs-dynamic-SQL-for-database-application-performance[^] Hope it helps.