I have table with 15 columns, 12 columns (January, February, March,..., December), to fill my table I should know the column to update.
我有15列的表,12列(一月,二月,十二月,三月,……),来填补我的表我应该知道更新列。
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文档或把文档读取到应用程序中。
For example, an update to a column will always result in updating a flag (another column) in the same table or some other table.
例如,对一列的更新总是会导致更新同一张表或者其它一些表中的标志(另一列)。
These enable your applications to update individual column values, or to scroll through result sets backward or forward.
这些方法使您的应用程序可以更新单个的列值,或者前后滚动结果集。
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.
在我们的应用程序中,我们将其更改为一个单独的列标题用作调整器的名称,同时也为每个订阅行为更新显示出来的信息。
Version 3: To UPDATE STATISTICS for a particular column of a particular table in a database.
版本3:用于数据库中特定表的特定列的UPDATESTATISTICS。
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选项为列分布抽样指定最小行数。
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”下的第一个元素。
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选项可以指定列分布进行抽样的最少行数。
Parameters that represent fields to update, such as firstname, must match the name of DataField property of a grid column.
代表更新字段的参数(例如firstname)必须与网格列的DataField属性名相匹配。
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的指示符变量,将支持空值的列设置为空值。
In a past column, I discussed several procedures that could be employed to accelerate application binary distribution and deployment and, in turn, update and install applications.
在之前的一篇专栏文章中,我讨论了用于加速应用程序部署的选项的几个程序,依次更新和安装应用程序。
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授权的话,那么您可以更新任何可更新的列。
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.
如果可能更新坐标列,但是源表包含一个时间戳列,其中记录了每行最后一次更新的时间,那么仍然可以避免批量复制。
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值。
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不会发生失败。
Next you used the SQL UPDATE statement to modify the column values for selected rows in a table.
然后使用SQLupdate语句来修改表中选定行的列值。
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部分中作为一个新属性添加的。
When you update the inventory, the PARTS_NUMBER column needs to assign a PART_NUMBER automatically.
更新清单时,需要为parts_number列自动分配一个PART_NUMBER。
The information in the DAD file is used, when the XML column is enabled, to create the insert, update and delete triggers that help in keeping the side tables in sync with the XML document.
当启用xml列时,使用这个DAD文件中的信息创建insert、update和delete触发器,从而帮助副表与XML文档保持同步。
The Derived column transformation USES values created by using expressions either to populate new columns in a data flow, or to update existing columns.
派生列转换使用通过表达式所创建的值来填充数据流中的新列或更新现有列。
As a result, updating a column can result in an error when there is a reference to the row you are attempting to update.
因此,当存在对尝试更新的行的引用时,更新列可能导致错误。
As a result, updating a column can result in an error when there is a reference to the row you are attempting to update.
因此,当存在对尝试更新的行的引用时,更新列可能导致错误。
应用推荐