How to: Delete Rows in a DataTable.
如何:删除数据表中的行。
You also can update and delete rows using the Data API.
还可以使用DataAPI更新和删除行。
Add the table to delete rows from to the Diagram pane.
将要从中删除行的表添加到“关系图”窗格中。
The delete statement is used to delete rows in a table.
DELETE声明常用来删除表中的数据。
If you try to delete rows from such a table, the trigger rolls back the delete.
如果尝试删除这类表中的行,该触发器将回滚删除操作。
To delete rows in a heap and deallocate pages, use one of the following methods.
若要删除堆中的行并释放页,请使用下列方法之一。
Describes how to delete rows in the database by deleting objects in the object model.
介绍如何通过删除对象模型中的对象来删除数据库中的行。
If you try to delete rows from such a table, the trigger rolls back the delete action.
如果您尝试删除此类表中的行,该触发器将回滚删除操作。
Gets or sets a value that indicates whether the data source view supports the ability to delete rows.
取得或设定值,这个值表示资料来源检视是否支援更新资料列。
You can modify the database by editing values in the cells of the grid, and you can add or delete rows.
可以通过编辑该网格单元格中的值对数据库进行修改,而且可以添加或删除行。
In general, however, you don't want to delete all rows from a table; instead, you'll selectively delete rows.
但是,一般地,您不希望删除表中的所有行;而是有选择地删除行。
For example, you can add and delete rows, input or change data, and easily navigate through large results sets.
例如,您可以加入与删除资料列,输入或变更资料,并且轻易地巡览大笔的结果集。
Now that you know how to add and delete rows, let's try building a simple application that demonstrates this in practice.
现在您已经了解了如何添加和删除行,接下来让我们尝试构建一个简单的应用程序来进行实际演示。
Where the two definitions differ can be seen when an attempt is made to delete rows from multiple parent tables that are referenced by a single child.
当试图从单个子表引用的多个子表中删除行时,就可以看出这两个定义的不同。
To avoid analyzing duplicate records, you delete rows from the CHECKING table with a timestamp greater than the one you pruned the pruned the audit log with.
为了避免分析重复的记录,从checking表中删除时间戳大于一个指定的、用于修剪日志的时间戳的行。
For example, you can delete rows containing information about customers who live in specific zip code or update XML (and non-XML data) only for customers who live in a given state.
例如,您可以删除包含居住在指定邮编地区的客户的信息的行,或者只更新居住在指定州的客户的XML(和非xml数据)。
Delete a row from a table with 10 indexes, and DB2 must remove all index entries associated with the deleted rows.
如果从一个带有10个索引的表删除一行,DB 2必须删除与被删除的行关联的所有索引条目。
Matched rows in the target table are updated or deleted based on update or delete clause specifications, as shown in Figure 2.
对于目标表中匹配的行,将依据更新或者删除子句规范来进行更新或者删除,如图2所示。
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语句的联合,因为您必须选择要修改的行,还必须指定如何修改它们。
By using the fields and the methods above, you can create new rows, update them, and delete them.
通过使用上面的字段和方法,可以创建新行、更新行和删除行。
In this case, they can issue a SELECT statement to identify rows that qualify then DELETE those rows.
在这种情况下,他们可以发出一条select语句来识别符合条件的行,然后再DELETE那些行。
You can also add new rows, delete and update existing rows.
还可以添加新行,删除和更新已有的行。
The first statement within the stored procedure is a DELETE to remove the existing rows in the local destination table SALES.
存储过程中的第一个语句是DELETE,它删除本地目标表 SALES 中现有的行。
When rows associated by package IDs are not required, SAP needs a quick and efficient mechanism to delete the data from the table.
当与包id相关的行不需要时,SAP需要一种快速而有效的机制来从表中删除该数据。
It is a good practice to delete any pruned rows from the table that you loaded in order to ensure that you do not load duplicate rows into the table at a later time.
从您装载的表中删除被修剪过的行,确保以后不会将重复的行装载到表中,这是一种很好的做法。
While a regular delete would delete the rows, it would not actually cause DB2 to recycle the space.
虽然常规的DELETE将删除这些行,但是它不会真正让DB 2回收这些空间。
This new DELETE algorithm in DB2 V8.2.2 can drastically reduce the logging and processing associated with the deletion of rows in an MDC table and its corresponding block indexes.
DB 2V8.2.2中这种新的DELETE算法可以显著减少与mdc表中行及其相应的块索引的删除相关的日志记录和处理。
The SQL delete statement enables you to identify (or restrict) the rows you want to delete through a WHERE clause.
SQLdelete语句允许通过where子句识别(或限制)要删除的行。
The old table transition table holds the original state of the affected rows before they are processed by the UPDATE or DELETE statement.
OLDTABLE过渡表保存了受影响的行在被update或delete语句处理之前的初始状态。
The old table transition table holds the original state of the affected rows before they are processed by the UPDATE or DELETE statement.
OLDTABLE过渡表保存了受影响的行在被update或delete语句处理之前的初始状态。
应用推荐