DEFAULT Specifies that the default value defined for the column is to replace the existing value in the column.
Specifies the condition to be met for the rows to be updated. This can be configured in ODBC data sources or by setting connection attributes or properties.For more information about predicates and search conditions, see Search Condition (Transact-SQL). To replace or modify large blocks of text, ntext, or image data, use WRITETEXT or UPDATETEXT instead of the UPDATE statement.CURRENT OF Specifies that the update is performed at the current position of the specified cursor. If the UPDATE statement could change more than one row while updating both the clustering key and one or more text, ntext, or image columns, the partial update to these columns is executed as a full replacement of the values.When you update a FILESTREAM field, you modify the underlying BLOB data in the file system.When a FILESTREAM field is set to NULL, the BLOB data associated with the field is deleted. WRITE(), to perform partial updates to FILESTREAM data. If an update to a row violates a constraint or rule, violates the NULL setting for the column, or the new value is an incompatible data type, the statement is canceled, an error is returned, and no records are updated. Sales Person ID); GO Examples in this section demonstrate how to update rows in a remote target table by using a linked server or a rowset function to reference the remote table.
For more information, see OUTPUT Clause (Transact-SQL).