您要查找的是不是:
- The SET clause specifies the columns to be updated, and their new values. SET子句指定将被更新的列和它们的新值。
- Table aliases are not accepted in the SET clause of an UPDATE statement. 在UPDATE语句的SET子句中,不接受表的别名。
- You can provide any expression of the correct data type in the SET clause. 您可以在SET子句中提供数据类型正确的任何表达式。
- There are therefore two parameters for each value: one for the SET clause and a different one for the WHERE clause. 因此,每个值都有两个参数:一个用于SET子句,另一个则用于WHERE子句。
- In this statement, the parameters in the SET clause are filled in with updated values for the changed record. 在该语句中,SET子句中的参数以已更改记录的更新值填写。
- The expressions used in the SET clause can also be subqueries that return only one value. SET子句中使用的表达式还可以是只返回一个值的子查询。
- The table or view specified in the SET clause must match that specified immediately following the UPDATE keyword. 在SET子句中指定的表或视图必须与指定的紧跟在UPDATE关键字后的表或视图相匹配。
- You do this by not including the columns in the SET clause of the UPDATE statement. 不将这些列包含在UPDATE语句的SET子句中即可达到此目的。
- The transmitted SQL statement includes the SET clause, to set the new values of the modified columns. 所传送的SQL语句包含SET子句,用以设置已修改列的新值。
- Columns prefixed with table aliases are accepted in the SET clause of an UPDATE statement. UPDATE语句的SET子句接受以表的别名作为前缀的列。
- These database options are set to default values when you create a database and can be changed by using the SET clause of the ALTER DATABASE statement. 当创建数据库时这些数据库选项设置为默认值,而且可以使用ALTER DATABASE语句的SET子句来更改这些数据库选项。
- These values may be referenced in the SET clause or elsewhere within this operator as well as elsewhere within this query. 可以在SET子句中、此运算符内的其他位置以及此查询内的其他位置引用这些值。
- For columns not specified in the SET clause, the inserted table contains the values as they existed before the UPDATE statement was issued. 对于在SET子句中未指定的列,插入的表包含在发出UPDATE语句前已存在的值。
- You can set cross-database ownership chaining for individual databases using the SET clause of the ALTER DATABASE statement. 可以使用ALTER DATABASE语句的SET子句为各个数据库设置跨数据库所有权链接。
- FROM Identifies the tables or views that supply the values for the expressions in the SET clause, and optional join conditions between the source tables or views. 指定为SET子句中的表达式提供值的表或视图,以及各个源表或视图之间可选的联接条件。
- UPDATE statements cannot specify the DEFAULT keyword as a value in the SET clause even if the column has a DEFAULT value defined in the corresponding member table. UPDATE语句不能将DEFAULT关键字指定为SET子句中的值,即使列在相应的成员表中定义了DEFAULT值。
- UPDATE statements that reference views with INSTEAD OF UPDATE triggers must supply values for all nonnullable view columns referenced in the SET clause. 引用带有INSTEAD OF UPDATE触发器的视图的UPDATE语句必须为SET子句中引用的所有不可为空的视图列提供值。
- Specifies the search condition that defines the rows from the source tables and views that qualify to provide values to the expressions in the SET clause. 指定搜索条件,该搜索条件定义源表和视图中可以为SET子句中的表达式提供值的行。
- The clause should be set off by a comma. 这个从句应该用逗号隔开。
- It is now our aim to set up a factory. 我们现在的目的是创办一座工厂。
