This can be done by using a timestamp or sequence number contained in the row, or by adding every column in the row to the WHERE clause of the UPDATE.
这可以通过使用数据行中包含的时间戳或序列号来进行,也可将数据行的每个列字段添加到UPDATE的where子句中。
You can use this update functionality to change documents in an XML column without XML parsing or reading the document into your application.
可以使用这种更新功能修改xml列中的文档,而不需要解析xml文档或把文档读取到应用程序中。
These enable your applications to update individual column values, or to scroll through result sets backward or forward.
这些方法使您的应用程序可以更新单个的列值,或者前后滚动结果集。
Figure 10 shows that an update statement is manipulating a column that contains private data.
图10显示一个更新语句正在操作一个包含私有数据的列。
For example, an update to a column will always result in updating a flag (another column) in the same table or some other table.
例如,对一列的更新总是会导致更新同一张表或者其它一些表中的标志(另一列)。
If the column is defined as null capable, then you must update the null indicator map accordingly.
如果列被定义为支持空值,那么您必须相应更新空指示符映射。
If updates to the coordinate columns are possible, you may still be able to avoid bulk copies if the source table contains a time stamp column that records the time of last update for each row.
如果可能更新坐标列,但是源表包含一个时间戳列,其中记录了每行最后一次更新的时间,那么仍然可以避免批量复制。
In our application, we change this to a single column title for the adjuster's name and also update the information shown for each subscription.
在我们的应用程序中,我们将其更改为一个单独的列标题用作调整器的名称,同时也为每个订阅行为更新显示出来的信息。
These update methods take two parameters: the column number or name that should be modified and the new value for the column.
这些更新方法将获得两个参数:应当修改的列号或列名以及该列的新值。
If you hold CONTROL privilege on a table, you can update values that pertain to that table, but if you hold explicit DBADM authority on the database, you can change any updatable column.
如果在某个表上拥有CONTROL权限,那么就可以更新属于该表的值,但是如果拥有数据库上显式的DBADM授权的话,那么您可以更新任何可更新的列。
Finally, the return clause returns the new node representing the scheduled termination date so that DB2 will update data in the DOCUMENT column with the modified data.
最后,return子句返回代表预定终止日期的新节点,所以DB 2将用修改后的数据更新document列中的数据。
This false negative scenario would not have the UPDATE cause a fail if a row change timestamp column was added to the EMPLOYEE table.
如果向EMPLOYEE表添加行修改时间戳列,则漏判场景中的UPDATE不会发生失败。
If an XML validation check constraint exists on the XML column of the table, the user may need to validate the new XML value before the update either manually or by creating a trigger.
如果在表的xml列上存在XML验证检查约束,在手动更新或者通过触发器更新之前,用户可能需要验证新的xml值。
The opposite operations can either be restricted or can be done using similar stored procedures (update in the relational column updates the XML document too).
也可以使用类似的存储过程限制或执行相反的操作(更新关系列导致同时更新XML文档)。
FOR UPDATE does not support grouping and ordering, so you cannot create a finder that would get a set of rows from the database and order them by a specific column.
FOR UPDATE不支持分组和排序。因此您不能创建finder来实现从数据库获得一组行并通过指定的列来排序的目的。
In explicit UPDATE STATISTICS operations in MEDIUM mode, a new SAMPLING SIZE option in the resolution clause specifies the minimum number of rows to sample for column distributions.
在使用MEDIUM模式的显式的UPDATESTATISTICS操作中,可以在resolution子句中使用新的SAMPLINGSIZE选项为列分布抽样指定最小行数。
Now you'll update the Column tag.
现在您已经更新了Column标签。
Update 14 USES the relational column value "CID" in the transform expression to produce a new element "customerid" as the first element under the root element "customerinfo."
更新14在转换表达式中使用关系列“CID”生成新元素“customerid”并让它成为根元素“customerinfo”下的第一个元素。
At this point, a real application would modify the count column appropriately by issuing the necessary SQL UPDATE statements.
这时,真正的应用程序将通过执行必要的SQLupdate语句来适当修改count列。
In explicit UPDATE STATISTICS operations in MEDIUM mode, a new SAMPLING SIZE option in the Resolution clause can specify the minimum number of rows to sample for column distributions.
在MEDIUM模式的显式的UPDATESTATISTICS操作中,resolution子句中新的SAMPLINGSIZE选项可以指定列分布进行抽样的最少行数。
We will perform UPDATE STATISTICS on the column item_num and then see how the two bins are constructed.
我们将在列 item_num 上执行UPDATESTATISTICS,看看这两种容器是如何构造的。
Prior to the DB2 for I 6.1 release, SQL Update and Insert statements could use an indicator variable with a value of -1 to set a null capable column to the null value.
在DB 2fori 6.1发布之前,SQLUpdate和insert语句能够使用一个值为- 1的指示符变量,将支持空值的列设置为空值。
Version 3: To UPDATE STATISTICS for a particular column of a particular table in a database.
版本3:用于数据库中特定表的特定列的UPDATESTATISTICS。
Next you used the SQL UPDATE statement to modify the column values for selected rows in a table.
然后使用SQLupdate语句来修改表中选定行的列值。
Parameters that represent fields to update, such as firstname, must match the name of DataField property of a grid column.
代表更新字段的参数(例如firstname)必须与网格列的DataField属性名相匹配。
When you update the inventory, the PARTS_NUMBER column needs to assign a PART_NUMBER automatically.
更新清单时,需要为parts_number列自动分配一个PART_NUMBER。
Computing the total value of the order from the individual order lines has been folded together with the update of the delivery column in ORDER_LINES.
通过更新order_lines中的delivery列,从各个订购项计算订单总值被合在一起。
Use UPDATE STATISTICS HIGH if queries have a multi-column indexed defined on join columns or filter columns.
如果查询中有属于多列索引的连接列或过滤列,则使用UPDATESTATISTICSHIGH。
As a report customization example, you can update the column report to include the masking method, which was added as a new property in Part 1 of this series.
作为一个报告定制的例子,更新columnreport,使之包括屏蔽方法,后者是在本系列的第1部分中作为一个新属性添加的。
In this case, the "Last statistics update" column is empty.
在这个例子中,“Laststatisticsupdate”列是空白的。
应用推荐