Mega Code Archive

 

Categories / MSSQL Tutorial / Insert Delete Update

 

The syntax of the UPDATE statement

UPDATE table_name SET column_name_1 = expression_1 [, column_name_2 = expression_2]... [FROM table_source [[AS] table_alias] [WHERE search_condition]