The content of a particular report is determined by a dynamic SQL query to one or more data sources.
特定报告的内容是由对一个或多个数据源发出的动态SQL查询确定的。
This is defined by an SQL query involving a server, database, table, and columns.
这是通过一个涉及服务器、数据库、表和列的SQL查询定义的。
It takes the connection object and a valid SQL query string as parameters.
它的参数是连接对象和一个有效的SQL查询字符串。
Even choosing only a subset of the columns from the view would be a simple SQL query.
即使是只从视图中选择列的一个子集,也能用一个简单的SQL查询实现。
This function can be easily invoked from a simple SQL query.
可以在简单的SQL查询中轻松地调用此函数。
I hope the above examples and analysis prove to be be helpful and serve as an introduction to SQL query tuning.
我希望上面的示例和分析证明是对您有所帮助的,并希望本文能充当SQL查询调优的简介。
Every SQL query that is entered must be parsed, optimized and executed.
输入的每个SQL查询都必须被解析、优化和执行。
Function (1) executes an SQL query on the database.
函数(1)对数据库执行一个SQL查询。
The edit-compile-run cycle, when all you are changing is a SQL query, can be pretty quick.
如果改变的只是SQL查询的话,那么这个编辑-编译-运行周期可能很快。
How do you measure response time and resource utilization of a SQL query?
如何测量SQL查询的响应时间和资源利用率呢?
Finally, configure a connector and write an SQL query to submit the room-booking information to the database.
最后,配置连接器,编写一个SQL查询语句来将客房预订信息提交给数据库。
You can make the SQL query on the predefined BPC database view.
您可以在预定义的BPC数据库视图上执行SQL查询。
As you can see, the above code combines three tokens to generate a complete SQL query.
就像你看到的,上面的代码用三段字串组成了一个完整的SQL查询语句。
It's quite easy to execute an SQL query and then create spreadsheet cells from each field of the query result set.
执行SQL查询并从查询结果集的每个字段中创建电子表格单元格,实现这些操作很简单。
Test the SQL query before using it in the XML file.
在使用之前先测试XML文件中的SQL查询。
You perform a simple SQL query, and then pass the results to your factory.
执行一个简单的SQL查询,然后将结果传递给工厂。
All SQL comparisons, SQL query execution, and SQL casting takes place in the database code page.
所有SQL比较、SQL查询执行以及SQL类型转换都必须在数据库代码页中进行。
You simply add the appropriate WHERE clause to the SQL query.
只需将合适的where子句添加到SQL查询中即可。
A cursor is a database structure that allows you to iterate through the results of an SQL query.
游标是一种数据库结构,它将允许您循环访问SQL查询的结果。
Commit the transaction and issue the SQL query again.
再次提交事务和发出SQL查询。
Collect statistics on your original SQL query.
收集关于原始sql查询的统计数据。
Make sure the column definition order matches the data fields of the SQL query.
请您列定义的顺序和SQL查询中的数据字段相符。
In the SQL query text box (Figure 5), enter the code shown in Listing 1.
在SQL查询文本框(图5)之中,输入如代码清单1所示的代码。
If you want to, change the SQL query.
如果你愿意,可以改掉下面的SQL查询语句。
Function (2) gets the number of rows in the result set returned from an SQL query.
函数(2)计算一个SQL查询返回的结果集中的行数。
The full SQL query must be enclosed in double-quotes.
整个SQL查询两侧必须加双引号。
Result: the SQL query fetches a single row that is present in the front end.
结果:SQL查询获取到出现在前端的一个行。
A dynamically generated SQL query is used to retrieve the number of matching rows.
动态生成的SQL查询用于检索匹配的行数。
Validation query: the SQL query that is used to validate connections before returning them to the caller.
验证查询:在将连接返回给调用方前用于验证连接的SQL查询。
Providing an SQL query to read from the database
提供一个SQL查询来从数据库读取数据
应用推荐