SQL statement distribution shows the distribution of dynamic and static SQL statements for a database.
SQL语句分布图显示数据库的动态和静态 SQL语句的分布情况。
SQL parameters found in your SQL statement are automatically discovered but can also be manually defined.
在您的sql语句中找到的SQL参数是自动发现的,但也可以手工定义。
Here is how an SQL injection works: First, assume an SQL statement accepts user-supplied data to look up a team member's contact information from a database without input validation rules.
下面是SQL注入的工作方式:首先,假设一条sql语句接受用户提供的数据,没有输入确认规则就可在数据库中查找团队成员的联系信息。
When the syntax of an SQL statement is fully known at compile time, the statement is referred to as static SQL.
如果在编译时一个SQL语句的语法是完全已知的,那么这个语句就称为静态 SQL。
With static SQL, the preparation steps for executing a SQL statement occur before the application is ever executed, thus offering the opportunity for better performance at runtime.
当使用静态SQL时,执行sql语句的准备步骤是在应用程序执行之前就进行的,因此可在运行时取得更好的性能。
At some level, the SQL UPDATE statement is the union of the SQL INSERT and DELETE statements, because you must select rows to modify as well as specify how to modify them.
在某种程度上,SQLupdate语句是SQLINSERT和delete语句的联合,因为您必须选择要修改的行,还必须指定如何修改它们。
The SQL explain facility provides detailed information about the access plan that the query optimizer chooses for an SQL statement.
SQL解释工具提供查询优化器为 SQL语句所选择的访问计划的有关详细信息。
Bind is the process that saves the access plan associated with a SQL statement into a DB2 SQL package.
绑定过程将与一个sql语句相关联的访问计划保存到一个DB 2 sql包中。
To run any SQL statement statically, it needs to have a DB2 SQL package associated with it.
要静态地运行任何sql语句,需要有一个与其相关联的DB 2 sql包。
Comprehensive expert advisors not only tune that particular SQL statement, they also recommend tuning activities that improve the overall performance of an entire DB2 SQL workload.
完善的专家建议程序不仅可以调优特定的sql语句,还可以推荐能够改善完整DB 2 SQL工作负载的整体性能的调优行为。
Varying-list dynamic SQL is typically used when an application builds the entire SQL statement from scratch.
当应用程序从头开始构建整个SQL语句时,通常会用到变动列表动态 SQL。
In SQL programming, a string containing any (mathematical) formula can be converted into an executable SQL statement with the SQL command PREPARE.
在SQL编程中,可以使用SQL命令PREPARE将含有任何(数学)公式的字符串转换成可执行的sql语句。
Here's how to configure a data group called SQL that USES two predefined data views to see SQL statement throughput and to sort overflows.
下面介绍如何配置一个名为SQL的数据组,这个数据组使用两个预定义数据视图来查看sql语句吞吐量和对溢出情况进行排序。
The federated server communicates a remote request for data to the remote relational data source through an SQL statement in the native SQL dialect of the data source.
联邦服务器通过数据源本地SQL方言中的 SQL语句将对数据的远程请求发送到远程关系数据源。
The attributes selected in this step, along with the list of measures, are used to create all of the SQL expressions, which are used in the SQL statement.
在这一步中选择的属性(以及度量的列表)用来创建sql语句中使用的所有SQL表达式。
SQL expressions will need to be created from these attributes to form the join predicates of the SQL statement.
需要从这些属性创建SQL表达式,从而形成sql语句的联结谓词。
The attributes on this side will need to be converted to SQL expressions to form the join predicates of the SQL statement.
这一边上的属性需要转换为SQL表达式,从而形成sql语句的联结谓词。
The view view provides the SQL editor control to enter the SQL statement defining the view.
提供输入定义视图的sql语句的SQL编辑器控件。
Then, you define an SQL statement to select the data from the database, which is executed using SQL: execute.
然后,定义一个sql语句来从这个数据库选择数据,此数据库用sql:execute执行。
For example, suppose the following static SQL statement is found in an embedded-SQL application.
例如,假设在一个嵌入式SQL应用程序中有以下的静态sql语句。
Convert the attributes and measures into SQL expressions, which are used to construct the SQL statement to query the cube model.
将属性和度量转换为SQL表达式,这些表达式用来构造对多维数据集模型进行查询的sql语句。
The first line of the query issues a SQL SELECT statement that invokes an industry-standard SQL function (XMLQUERY).
查询的第一行发出一个SQLselect语句,其中调用了一个行业标准的SQL函数(XMLQUERY)。
You can click the Show SQL button to see what the underlying SQL statement looks like so far.
可以点击ShowSQL按钮来看看底层的sql语句到目前为止是什么样子?
Replace poor performing SQL with a more optimal SQL statement without modifying the program source code.
无需修改程序源代码即可使用经过优化的sql语句替换表现不佳的SQL。
This solution uses the SQL and XQuery editor (default option) to create the SQL statement.
该解决方案使用SQL和XQuery编辑器(默认选项)创建 SQL语句。
For this article, I will be using a combination of fixed-list dynamic SQL and static embedded SQL (for the UPDATE statement) to create a format-based handler.
对于本文,我将结合使用固定列表动态sql和静态嵌入式SQL(用于update语句)来创建一个基于格式的Handlder程序。
The SQL Explorer page displays a summary of all SQL statement types that have been executed on the current database server.
SQLExplorer页面显示在当前数据库服务器上执行的所有sql语句类型的汇总信息。
The statement heap is used as a workspace for the SQL compiler during compilation of an SQL statement.
在sql语句的编译期间,语句堆(statement heap)用作SQL编译器的工作空间。
The 'view' view provides the SQL editor control to enter the SQL statement defining the view.
view视图提供了SQL编辑器控件,可以在其中输入用于定义视图的sql语句。
SQL statement completion whereupon typing an SQL keyword such as SELECT, or where an operator is expected, a context window is shown displaying possible ways to complete the statement.
sql语句完成(SQL statement completion)当输入SELECT之类的SQL关键字时,或者在期望一个操作符时,就会出现一个上下文窗口,其中显示用于完成语句的可能的方式。
应用推荐