图10显示一个更新语句正在操作一个包含私有数据的列。
Figure 10 shows that an update statement is manipulating a column that contains private data.
不需要为更新指定sql语句,原因是关系型DAS可以从模式和联系人数据对象的更改概要中派生它。
There is no need to specify a SQL statement for updates because the Relational DAS derives this from the model and the contact data object's change summary.
来自HTTP请求的客户个人数据作为参数传递给更新语句;不需要修改。
The customer profile data from the HTTP request is passed as a parameter to the update statement; no modifications are needed.
IBMDB 2使程序员可以用熟悉的sql语句更新和删除XML数据。
IBM DB2 enables programmers to update and delete XML data using familiar SQL statements.
为了解释新的DB2 9.5XML更新功能,我们使用下面的CREATETABLE和INSERT语句定义示例表和数据。
To illustrate the new DB2 9.5 XML update functionality, the sample table and data defined by the following CREATE TABLE and INSERT statements are used.
清单19. bean内映射的Employee数据访问对象的更新方法和语句。
Listing 19. Update method and statement for the in-the-bean mapping Employee data access object.
要更新和删除存储在DB 2中的XML数据,可使用SQLUPDATE和delete语句。
To update and delete XML data stored in DB2, you use SQL update and delete statements.
清单9包含一个交互式sql语句,用于更新FPMLADMIN. FPML43表的document列中的XML数据。
Listing 9 contains an interactive SQL statement that updates XML data in the DOCUMENT column of the FPMLADMIN.FPML43 table.
在范例11中,我们为electricitydeal加上了select - before - update,这会对瞬时(transient)对象或分离(detached)对象产生额外的select语句,但却能避免不必要的数据库更新。
In example 11, we used "select-before-update" for ElectricityDeal, which incurs an extra select for your transient or detached object. But it does avoid unnecessary updates to your database.
“数据表查询向导”对话框可以帮助你构造你自己的查询语句,之后数据表会被新数据更新。
The "DbTable query Wizard" dialog opens to help you construct your query, after which the table is updated with the new data.
应用程序提交一个SQLupdate语句,把更新后的文档传输给数据库服务器。
The application submits an SQL update statement and transmits the updated document to the database server.
传统数据库系统可以使用一系列的sql语句,通过某种形式的专有客户端软件或API来执行数据检索和更新功能。
Traditional database systems allow you to perform data retrieval and update functions using a series of SQL statements that are executed through some form of proprietary client software or API.
因此,用于更新统计数据的update语句可能失败并产生SQL 1227n错误消息。
Hence, the update statements to update the statistics can fail with the SQL1227N error message.
这使得数据库系统管理员可以优化没有使用更新语句处的性能,或使用更新语句时也可以防止死锁。
This allows the database administrator to optimize the performance where the update syntax is not used, or to prevent deadlocks when it is used.
乐观事务锁不能用于在单个update语句中更新数据行集合,因此在这种情况下,很难进行错误处理。
Optimistic transaction locking should not be used to update sets of rows in a single update statement, as error handling in this case is very difficult.
例如,有些数据库在select语句上提供了特殊的语法,声明用来更新select语句所选中的行。
For example, some databases provide special syntax on the select statements to declare the intentions of updating the rows selected by the select statement.
关系型更新数据源包含单个sql语句。
AIO的功能是在SQL语句访问或更新数据库数据时,执行磁盘I/O。
The function of AIO is to perform disk I/O when SQL statement accessing or updating database data.
动态sql语句自动使用这些更新的统计数据。
Dynamic SQL statements automatically use these updated statistics.
如要看对实体e JB Category Bean下的数据库表进行更新的效果,请登录到数据库的命令行界面,并输入以下sql语句。
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.
最后,在这个事务中还暴露了有关数据更改操作的另一个更新颖的特性:那就是INCLUDE -子句,像任何其他数据更改语句一样,INSERT可以使用这个子句。
Finally, there is one more novel feature related to data-change-operations exposed in this transaction: the INCLUDE-clause which INSERT, like any other data-change-operation, can use.
清单8演示如何从XML中提取出customerid并用它创建更新数据库的sql语句。
Listing 8 shows how to extract the customerid from the XML and use it to create an update SQL command for the database.
发送到缓冲表的远程数据源的更新语句数。默认值为1。调整该值可大大提高更新性能。
The number of update statements sent to the remote data source for buffered tables. 1 is the default. Adjusting this value can greatly increase update performance.
具体包括用存储过程与用SQL语句的对比、使用带参存储过程以及通过存储过程进行数据库表的更新。
In detail, it includes the comparison of simple stored procedure with SQL, stored procedure with parameters, and use stored procedure to update database table.
在OLTP系统中,最终用户日常性地向数据库发布个人数据更新的语句。
In OLTP systems, end users routinely issue individual data modification statements to the database.
SQL语句通常用于完成一些数据库的操作任务,比如在数据库中更新数据,或者从数据库中检索数据。
SQL statements are usually used to complete some tasks of database operations, such as updating the database data or from the database retrieval of data.
sql语句可以用来执行各种各样的操作,例如更新数据库中的数据,从数据库中提取数据等。
SQL statements can be used to perform various operations, such as updating data in the database, extract data from the database and so on.
sql语句可以用来执行各种各样的操作,例如更新数据库中的数据,从数据库中提取数据等。
SQL statements can be used to perform various operations, such as updating data in the database, extract data from the database and so on.
应用推荐