If ' N' is not specified, SQL Server converts the string to the code page that corresponds to the default collation of the database or column.

updating a specific row in sql-8

For more information, see WITH common_table_expression (Transact-SQL). For information about table hints, see Table Hints (Transact-SQL).

TOP ( ) Specifies one or more table hints that are allowed for a target table. @Note When referencing the Unicode character data types nchar, nvarchar, and ntext, 'expression' should be prefixed with the capital letter ' N'.

Compound assignment operator: = Add and assign -= Subtract and assign *= Multiply and assign /= Divide and assign %= Modulo and assign &= Bitwise AND and assign ^= Bitwise XOR and assign |= Bitwise OR and assign Returns updated data or expressions based on it as part of the UPDATE operation.

The OUTPUT clause is not supported in any DML statements that target remote tables or views.

Transaction isolation levels can cause significant lags in row positioning if client application design lets transactions remain open for long periods of time.

By default, the SQL Server Native Client OLE DB provider uses the read-committed isolation level specified by DBPROPVAL_TI_READCOMMITTED.

For more information, see OUTPUT Clause (Transact-SQL).

FROM Specifies that a table, view, or derived table source is used to provide the criteria for the update operation. If the object being updated is the same as the object in the FROM clause and there is only one reference to the object in the FROM clause, an object alias may or may not be specified.

A view with an INSTEAD OF UPDATE trigger cannot be a target of an UPDATE with a FROM clause.