blocks|key|1808564|text|Ad+hoc在拉丁语中的意思是“为了这个目的”。您可以将其称为“即时”查询，或“就这样”查询。这是一种SQL查询，您只需在需要的地方松散地键入它即可|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1808565|var+newSqlQuery+=+"SELECT+*+FROM+table+WHERE+id+=+"+%2B+myId;|code-block|syntax|javascript|1808566|根据myId的值，每次执行该行代码时，...which都是一个完全不同的查询。即席查询的对立面是预定义的查询，例如存储过程，在这种查询中，您已经创建了一个查询，用于从该表中进行选择的整个通用目的(比方说)，并将ID作为变量传递。|offset|length|style|CODE|1808567|entityMap^0|0|0|2|4|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@$I|R|J|S|K|L]]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

Ad hoc is latin for "for this purpose". You might call it an "on the fly" query, or a "just so" query. It's the kind of SQL query you just loosely type out where you need it

<pre><code>var newSqlQuery = "SELECT * FROM table WHERE id = " + myId;
</code></pre>

...which is an entirely different query each time that line of code is executed, depending on the value of <code>myId</code>. The opposite of an ad hoc query is a predefined query such as a Stored Procedure, where you have created a single query for the entire generalized purpose of selecting from that table (say), and pass the ID as a variable.

blocks|key|2022156|text|在Sql+Server中，“即席查询”也用于即席分布式查询。这些是通过OpenRowset或OpenDatasource在其他服务器上进行的即席查询。仅在配置了特定分布式查询之后才允许即席分布式查询。这是一个服务器配置选项。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2022157|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

In Sql Server "Ad Hoc Query" is also used for Ad Hoc Distributed Queries. These are ad hoc queries on an other server via OpenRowset or OpenDatasource. Ad Hoc Distributed Queries are only allowed after configuring so. This is a Server configuration option.

blocks|key|2022267|text|我还想补充说，即席查询很容易受到SQL注入攻击。我们应该尽量避免使用它，而使用参数化的SQL+(like+PreparedStatement+in+Java)。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2022268|entityMap|0|LINK|mutability|MUTABLE|url|http://docs.oracle.com/javase/tutorial/jdbc/basics/prepared.html^0|1C|U|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

Also want to add that ad hoc query is vulnerable to SQL injection attacks. We should try to avoid using it and use parameterized SQLs instead (<a href="http://docs.oracle.com/javase/tutorial/jdbc/basics/prepared.html" rel="nofollow">like PreparedStatement in Java</a>).

blocks|key|1808828|text|点对点查询是在发出查询之前无法确定的查询。它是为了在需要时获取信息而创建的，它由动态构造的SQL组成，通常由桌面上驻留的查询工具构造。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1808829|查看：http://www.learn.geekinterview.com/data-warehouse/dw-basics/what-is-an-ad-hoc-query.html|offset|length|1808830|entityMap|0|LINK|mutability|MUTABLE|url|http://www.learn.geekinterview.com/data-warehouse/dw-basics/what-is-an-ad-hoc-query.html^0|0|3|2G|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

An Ad-Hoc Query is a query that cannot be determined prior to the moment the query is issued. It is created in order to get information when need arises and it consists of dynamically constructed SQL which is usually constructed by desktop-resident query tools.

Check: <a href="http://www.learn.geekinterview.com/data-warehouse/dw-basics/what-is-an-ad-hoc-query.html" rel="noreferrer">http://www.learn.geekinterview.com/data-warehouse/dw-basics/what-is-an-ad-hoc-query.html</a>

blocks|key|2022390|text|即席查询是那些尚未定义且不需要定期使用的查询，因此它们不包括在典型的报告或查询集中|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2022391|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Ad hoc queries are those that are not already defined that are not needed on a regular basis, so they're not included in the typical set of reports or queries

blocks|key|2022450|text|即席查询是一种计算机定义类型。这意味着这个查询是专门设计用来在需要时获取任何信息的。预定义的。请参阅此https://www.youtube.com/watch?v=0c8JEKmVXhU|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2022451|entityMap|0|LINK|mutability|MUTABLE|url|https://www.youtube.com/watch?v=0c8JEKmVXhU^0|1F|17|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

Ad hoc query is type of computer definition. Which means this query is specially design to obtain any information when it is only needed. Predefined.
refer this <a href="https://www.youtube.com/watch?v=0c8JEKmVXhU" rel="nofollow noreferrer">https://www.youtube.com/watch?v=0c8JEKmVXhU</a>

blocks|key|1809050|text|点对点查询是在发出查询之前无法确定的查询。它是为了在需要时获取信息而创建的，它由动态构造的SQL组成，通常由桌面上驻留的查询工具构造。即席查询并不驻留在计算机或数据库管理器中，而是根据数据用户的需要动态创建的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1809051|在SQL中，即席查询是一种松散类型的命令/查询，其值取决于某个变量。每次执行命令时，结果都会有所不同，具体取决于变量的值。它不能预先确定，通常属于动态编程SQL查询。即席查询是短暂的，是在运行时创建的。|1809052|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

An Ad-Hoc Query is a query that cannot be determined prior to the moment the query is issued. It is created in order to get information when need arises and it consists of dynamically constructed SQL which is usually constructed by desktop-resident query tools.
An ad hoc query does not reside in the computer or the database manager but is dynamically created depending on the needs of the data user.

In SQL, an ad hoc query is a loosely typed command/query whose value depends upon some variable. Each time the command is executed, the result is different, depending on the value of the variable. It cannot be predetermined and usually comes under dynamic programming SQL query. An ad hoc query is short lived and is created at runtime.

blocks|key|2022619|text|Ad-hoc语句只是T-SQL语句，它有一个Where子句，而Where子句实际上可以有一个文字，如：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2022620|Select+*+from+member+where+member_no=285;|code-block|syntax|javascript|2022621|或变量：|2022622|declare+@mno+INT=285;
Select+*+from+member+where+member_no=@mno|2022623|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Ad-hoc Statments are just T-SQL Statements that it has a Where Clause , and that Where clause can actualy have a literal like :

<pre><code>Select * from member where member_no=285;
</code></pre>

or a variable :

<pre><code>declare @mno INT=285;
Select * from member where member_no=@mno
</code></pre>

I'm reading a book about SQL. In that book there's the term Ad Hoc Query, which I don't understand.

What exactly is an ad hoc query?

What is Ad Hoc Query?

数据库管理

SQL注入攻击

数据库

服务器

我正在读一本关于SQL的书。在这本书里有一个术语特别查询，我不明白。什么是即席查询？

问什么是即席查询？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问什么是即席查询？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问什么是即席查询？
EN