In order to use the procedure, it must be registered in the database with the following SQL statement.
为了使用这个存储过程,必须用下面的sql语句将该过程注册到数据库中。
SQL statement distribution shows the distribution of dynamic and static SQL statements for a database.
SQL语句分布图显示数据库的动态和静态 SQL语句的分布情况。
Even though the program runs on the application server, it will use the database clock in the SQL statement.
尽管程序在应用服务器上运行,但是它将使用sql语句中的数据库时钟。
Without these statistics, the database manager could make a decision that would adversely affect the performance of an SQL statement.
如果没有这些统计信息,数据库管理器可能会做出对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语句接受用户提供的数据,没有输入确认规则就可在数据库中查找团队成员的联系信息。
It then USES its parent request to find the right database statistics based on the connection's description, and to find statement statistics based on the SQL key string.
然后它用它的双亲请求,根据连接的描述找到正确的数据库统计值,并根据sql键字符串找到语句统计值。
First, you should turn off autocommit mode so the results of each SQL statement aren't automatically committed to the database.
首先,应当关闭自动提交模式,这样,每条sql语句的结果不会被自动提交给数据库。
The application submits an SQL update statement and transmits the updated document to the database server.
应用程序提交一个SQLupdate语句,把更新后的文档传输给数据库服务器。
The SQL JOIN statement has long been in the toolkit of database programmers, allowing you to combine the data contained in two or more relational database tables based upon a common attribute.
数据库编程人员对SQLJOIN语句的使用由来已久,通过该语句可以基于相同的属性将两个或更多关系数据库表中的数据组合到一起。
With these statistics information database manager could make a decision that would increase the performance of an SQL statement.
数据库管理器通过这些统计信息可以做出决策以提高SQL 语句的性能。
DB2 UDB provides several tools that can be used to monitor database server activities, or to analyze how an SQL statement accesses data; each serves a different purpose.
DB 2UDB提供了多个工具,可以用于监控数据库服务器的活动,或分析sql语句如何访问数据;每个工具都服务于不同的目的。
So if an access plan is reused, a database server requires less CPU resources to execute the corresponding SQL statement repeatedly.
因此,如果一个访问计划被重用,则数据库服务器重复执行相应sql语句所需的CPU资源将减少。
Another important factor that affects SQL statement performance is database statistics.
影响sql语句性能的另一个重要因素是数据库统计。
From the performance perspective, dynamic SQL statement can be prepared once and executed multiple times, reusing the same database access plan.
从性能的角度来看,动态sql语句只需要准备一次就可以执行多次,可以重用相同的数据库访问计划。
This program executes a dynamically prepared DB2 SQL statement to retrieve CURRENT DATE from the database.
这个程序执行一条动态生成的DB2SQL语句,从数据库中获取CURRENTDATE。
Finally, we retrieve the results of our SQL statement and close the connection to the database.
最后,我们将检索sql语句的结果并关闭数据库连接。
ISOLATION level is set at the session level using set ISOLATION, set at the SQL statement level using the WITH clause or set at the database level using a database Configuration parameter.
使用SETISOLATION在会话级、使用with子句在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所示。
In this case, the only parsing is copying the data values from the message's mapped data structure to the database table's INSERT SQL statement.
这种情况下,解析之需要将数据值从消息的映射数据结构复制到数据库表的INSERTsql语句。
A hacker enters a malformed SQL statement into the textbox that changes the nature of the query so that it can be used to break into, alter, or damage the back-end database.
黑客向文本框中输入不正确的sql语句以更改查询的性质,从而可以使用它入侵、更改或损坏后端数据库。
The access plan is created by the database engine based on the SQL statement that is submitted.
访问计划是由数据库引擎根据提交的sql语句创建的。
The function of AIO is to perform disk I/O when SQL statement accessing or updating database data.
AIO的功能是在SQL语句访问或更新数据库数据时,执行磁盘I/O。
For example, you make a database connection via a JDBC connection; and to send an SQL query to a database, you create a JDBC Statement object from the appropriate connection object.
例如,通过JDBCConnection建立数据库连接;并且为了向数据库发送SQL查询,从相应的Connection对象创建一个JDBCStatement对象。
The federated database simply takes the SQL statement, translates it into valid Oracle syntax and passes it onto the Oracle database for processing.
联邦数据库提取sql语句,将它转换成有效的oracle语法,并传递到Oracle数据库上进行处理。
In the updateCatalog function, retrieve the form field values and create an SQL statement to add a row to database table Catalog.
在updatecatalog函数中,获取表单字段值,并创建一条sql语句,以便将一行添加到数据库表Catalog中。
Hibernate generates the SQL statement strings and executes them against the database using the JDBC prepare and execute operations.
Hibernate生成sql语句字符串并使用JDBC准备和执行操作在数据库中执行它们。
Note: This is equivalent to selecting a database column in the where clause of a SQL statement.
注意:这相当于在sql语句的where子句中选择一个数据库列。
To see the effect of updating the database table underlying the CategoryBean entity EJB, sign on to the database's command-line interface and enter the following SQL statement.
如要看对实体e JB Category Bean下的数据库表进行更新的效果,请登录到数据库的命令行界面,并输入以下sql语句。
The SQL Explorer page displays a summary of all SQL statement types that have been executed on the current database server.
SQLExplorer页面显示在当前数据库服务器上执行的所有sql语句类型的汇总信息。
We then created a page design element within the Notes database, which contained the XSLT style sheet code that would transform the XML document into an SQL statement.
然后我们在Notes数据库中创建一个页面设计元素,它包含了将XML文档转换成sql语句的xslt样式表代码。
应用推荐