In this case, they can issue a SELECT statement to identify rows that qualify then DELETE those rows.
在这种情况下,他们可以发出一条select语句来识别符合条件的行,然后再DELETE那些行。
Use the create type statement to create a structured type, and use the DROP statement to delete a structured type.
可以使用CREATEtype语句创建一个结构化类型,并使用drop语句删除结构化类型。
To remove the document, issue a DELETE statement with an appropriate WHERE predicate.
为了删除文档,需要执行delete语句,并加上适当的where谓词。
The last tasks are to submit a SELECT statement and to delete an item.
最后一个任务是提交select语句并删除一个项。
The first statement within the stored procedure is a DELETE to remove the existing rows in the local destination table SALES.
存储过程中的第一个语句是DELETE,它删除本地目标表 SALES 中现有的行。
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 SQL delete statement enables you to identify (or restrict) the rows you want to delete through a WHERE clause.
SQLdelete语句允许通过where子句识别(或限制)要删除的行。
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。
For example, let's say you chose a Time to trigger action of Before for an trigger that is fired by a DELETE statement.
例如,假设您的触发器选择的Timeto triggeraction是Before,触发事件是delete语句。
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语句中同时只能指定两者之一。
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变量
A searched delete statement deletes multiple rows if the search condition does not uniquely identify a single row.
如果搜索条件不唯一标识单行,则搜索DELETE语句删除多行。
You can delete an existing index in a table with the DROP index statement.
你可以将现有的索引通过DROPINDEX语句进行取消操作。
The delete statement is used to delete rows in a table.
DELETE声明常用来删除表中的数据。
The delete statement is used to delete rows in a table.
DELETE声明常用来删除表中的数据。
应用推荐