什么是动态查询.. [英] what is dynamic query..

问题描述

什么是动态查询...以及任何一个给出定义和示例..

what is dynamic query.. and any one give definition and example..

推荐答案

定义：

Definition:

Quote：

存储过程中的动态SQL是单个Transact-SQL语句或存储在变量中并使用执行的一组语句一个SQL命令。

A dynamic SQL in a stored procedure is a single Transact-SQL statement or a set of statements stored in a variable and executed using a SQL command.

- 在存储过程中构建动态SQL [ ^ ]



通过以下非常好的文章浏览互联网。

在存储过程中构建动态SQL [ ^ ]

SQL SERVER - 执行动态SQL [ ^ ]

在SQL Server中执行动态SQL命令 [ ^ ]



希望，它有帮助：）

--Building Dynamic SQL In a Stored Procedure[^]

Go through following very good articles already available over the internet.
Building Dynamic SQL In a Stored Procedure[^]
SQL SERVER – Executing Dynamic SQL[^]
Execute Dynamic SQL commands in SQL Server[^]

Hope, it helps :)

通常，动态SQL语句是以字符串形式存储的SQL查询一个变量，然后由Exec命令执行。



查看下面的链接。它有很多例子：



在存储过程中构建动态SQL [ ^ ]

Generally, a dynamic SQL statement is a SQL query stored as a string in a variable and then executed by Exec command.

Check the link below. It has a lot of examples:

Building Dynamic SQL In a Stored Procedure[^]

谷歌是你的朋友，好好经常访问他：他可以更快地回答查询我们可以。

一个简单的谷歌把我带到了MSDN： https://technet.microsoft.com/en-us/library/aa237255(v = sql.80）.aspx [ ^ ]



将来，请尝试自己做至少基础研究，不要浪费你的时间或我们的时间。

Google is your friend, be nice and visit him often: he can answer queries a lot faster than we can.
A simple Google took me right to MSDN: https://technet.microsoft.com/en-us/library/aa237255(v=sql.80).aspx[^]

In future, please try to do at least basic research yourself, and not waste your time or ours.

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