Updating a record in sql

DEFAULT Specifies that the default value defined for the column is to replace the existing value in the column.This can also be used to change the column to NULL if the column has no default and is defined to allow null values.

Specifies the condition to be met for the rows to be updated.The CTE result set is derived from a simple query and is referenced by UPDATE statement.Common table expressions can also be used with the SELECT, INSERT, DELETE, and CREATE VIEW statements.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'.The search condition can also be the condition upon which a join is based.

You must have an account to comment. Please register or login here!