Правильный синтаксис оператора UPDATE:
(Отметьте один правильный вариант ответа.)
Варианты ответа
UPDATE { table_name WITH ( table_hint_limited [ ...n ] ) | view_name | rowset_function_limited } [ SET ] { column_name = { expression | DEFAULT | NULL } | @variable = expression | @variable = column = expression } [ ,...n ] FROM { table_source } [ ,...n ] ] [ WHERE search_condition ]
UPDATE { table_name WITH ( table_hint_limited [ ...n ] ) | view_name | rowset_function_limited } SET { column_name = { expression | DEFAULT | NULL } | @variable = expression | @variable = column = expression } [ ,...n ] { { [ FROM { table_source } [ ,...n ] ] [ WHERE search_condition ] } | [ WHERE CURRENT OF { { [ GLOBAL ] cursor_name } | cursor_variable_name } ] } [ OPTION ( query_hint [ ,...n ] ) ] (Верный ответ)
UPDATE { table_name WITH ( table_hint_limited > [ ...n ] ) | view_name | rowset_function_limited } SET column_name = expression | DEFAULT | NULL | @variable = expression | @variable = column = expression } [ ,...n ]
