Even better, prototyping reports with SQL is easy — you run your prototype report, and if the results aren't what you need, you tweak the SQL query or write a new query, and try again.
甚至用SQL生成报告原型也很容易——运行原型报告，如果结果不是所需要的结果，那么可以修改SQL查询或者编写新的查询，然后再试一试。
Now, when the same query is run, the native SQL that is generated is a single select statement joining the two tables from the different catalogs at the database tier as shown in Illustration 10.
现在，当同一个查询运行时，生成的原生sQL是单个选择语句，在语句在数据库层联接来自不同目录的两个表，如图10所示。
The only new key in this options array is the SQL key, which defines the inner SQL query to run in order to populate the element.
此选项数组中的惟一新键为sql键，它定义了运行内部sql查询以填充元素。
Run the SQL query in the prepared statement with the execute ([array input_parameters]) function.
用execute ([array input _ parameters])函数执行预置语句中的SQL查询。
The db2_execute statement returns true or false when completed, and the result set of the query must be bound to a variable before the SQL statement is run.
db2_execute语句在完成时将返回true或false，而且必须将查询的结果集绑定到变量，然后才能运行sql语句。
The query and metadata caching results in the second run always executes faster than the first run. For example, looking at this Entity SQL query.
由于查询与元数据缓存的存在，使得第二次运行的执行速度总是比第一次运行快。
Query, which specifies the inner SQL query to run when populating the element.
指定填充元素时要运行的内部SQL查询。
Then run or edit the query to display the various editors for the query, and click SQL editor.
然后您可以运行或者编辑查询以显示查询的不同的编辑器，并点击SQL editor。
The edit-compile-run cycle, when all you are changing is a SQL query, can be pretty quick.
如果改变的只是SQL查询的话，那么这个编辑-编译-运行周期可能很快。
Notice that this second SQL query contains a question mark (?) placeholder - at run-time, this placeholder is replaced by the current value of the fields specified in the data array.
注意，第二个SQL查询包含了一个问号(？)占位符—运行时，此占位符被data数组中指定的字段当前值替代。
“执行sql”以运行该查询。
If a query contains an error not detected during SQL verification, the database will detect the error when you run the query.
如果查询包括在SQL验证过程中未检测到的错误，则当运行该查询时，数据库将检测到该错误。
To determine which version of SQL Server 2000 is running, connect to SQL Server 2000 by using Query Analyzer, and then run the following code.
要确定哪个版本的SQLServer 2000正在运行，连接到SQL Server 2000通过使用查询分析器，然后运行下面的代码。
To determine which version of SQL Server 2000 is running, connect to SQL Server 2000 by using Query Analyzer, and then run the following code.
要确定哪个版本的SQLServer 2000正在运行，连接到SQL Server 2000通过使用查询分析器，然后运行下面的代码。
应用推荐