The delete statement is used to delete rows in a table.
DELETE声明常用来删除表中的数据。
The delete statement deletes all rows from the specified table that satisfy an optional WHERE clause.
delete语句从指定表中删除满足可选where子句的所有行。
"We did not want this data, have never used any of it on our products and services, and have sought to delete it as quickly as possible," the statement said.
“我们并不希望这种数据,从来没有使用过它对我们的产品和服务,并试图删除它尽可能快,”该声明说。
The first data modification technique discussed was data deletion, which is performed by using the SQL DELETE statement.
讨论的第一种数据修改技术是数据删除,这通过使用SQLdelete语句来执行。
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语句的联合,因为您必须选择要修改的行,还必须指定如何修改它们。
Use the create type statement to create a structured type, and use the DROP statement to delete a structured type.
可以使用CREATEtype语句创建一个结构化类型,并使用drop语句删除结构化类型。
In these cases, it strongly recommend that the reader USES the native CLRPFM command rather than the SQL DELETE statement.
这种情况下,强烈建议读者使用原生的CLRPFM命令,而不是SQLdelete语句。
After the execution of the UPDATE, INSERT, and DELETE statements, an additional variable is available to check the result of the statement.
执行完update、INSERT和delete语句后,将使用额外的一个变量来检查语句的结果。
The first statement within the stored procedure is a DELETE to remove the existing rows in the local destination table SALES.
存储过程中的第一个语句是DELETE,它删除本地目标表 SALES 中现有的行。
The SQL delete statement enables you to identify (or restrict) the rows you want to delete through a WHERE clause.
SQLdelete语句允许通过where子句识别(或限制)要删除的行。
You could use the DELETE SPARQL statement with a WHERE clause to find the data by name rather than URI, which would enable you to have an identical function header to the SQL version.
您可以将DELETEsparql语句与where子句结合使用以按名称而不是按uri查找数据,这将拥有与SQL版本相同的函数头。
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语句处理之前的初始状态。
Select all text below the rem (remark) statement, and then delete it.
选择rem (remark)语句下方的所有文本,然后删除它们。
If the correction is to delete the problematic row data, delete the row using the BEGIN WORK WITHOUT REPLICATION statement.
如果更正措施是删除有问题的行数据,那么使用BEGINWORKWITHOUT replication语句删除行。
For the merge statement that contains only the update clause or the delete clause, the inner join is performed between source and target table.
对于仅包含更新子句或删除子句的merge语句,内部联接会在源表与目标表之间执行。
If the data is issuing a delete command on a database row, make sure that you add limit 1 to the end of your statement to minimize damage.
如果数据是对数据库行发出delete命令,请确保在语句最后添加limit1,以尽可能减少损失。
From an SQL perspective, the merge statement is a DML SQL statement with the same semantics as other DML statements, including insert, update, and delete.
从SQL的角度看,merge语句是与其他dml语句具有相同语义的DML sql语句,包括insert、update、以及delete。
SELECT, however, isn't the only SQL statement supported by YQL; you can also use INSERT, DELETE, and UPDATE queries to manipulate data on third-party services using the same SQL syntax.
但是,SELECT并非YQL支持的惟一SQL语句;您还可以使用INSERT、DELETE和UPDATE查询、运用相同的 SQL语法操作第三方服务上的数据。
Use TRY..CATCH construct or check the @@ERROR variable after executing a data manipulation statement (like INSERT/UPDATE/DELETE).
在执行数据操作语句(像INSERT/UPDATE/DELETE)之后,使用TRY..CATCH结构或者检查该@@ERROR变量
The delete and update commands are mutually exclusive for the when matched clause, which means that only one of them can be specified in a merge statement at a time.
对于子句 whenmatched,delete与update命令互斥,这意味着在merge语句中同时只能指定两者之一。
A searched delete statement deletes multiple rows if the search condition does not uniquely identify a single row.
如果搜索条件不唯一标识单行,则搜索DELETE语句删除多行。
Update with join throws "The MERGE statement attempted to UPDATE or DELETE the same row more than once. ""
更新加入抛出“MERGE语句试图更新或删除相同的行不止一次。”
Update with join throws "The MERGE statement attempted to UPDATE or DELETE the same row more than once. ""
更新加入抛出“MERGE语句试图更新或删除相同的行不止一次。”
应用推荐