UPDATE |
Mise à jour |
|---|---|
| Microsoft SQL Server |
Syntaxe
|
[ WITH common_table_expression [...n] ] UPDATE [ TOP ( expression ) [ PERCENT ] ] { { table_alias | object | rowset_function_limited [ WITH ( Table_Hint_Limited [ ...n ] ) ] } | @table_variable } SET { column_name = { expression | DEFAULT | NULL } | { udt_column_name.{ { property_name = expression | field_name = expression } | method_name ( argument [ ,...n ] ) } } | column_name { .WRITE ( expression , @Offset , @Length ) } | @variable = expression | @variable = column = expression | column_name { += | -= | *= | /= | %= | &= | ^= | |= } expression | @variable { += | -= | *= | /= | %= | &= | ^= | |= } expression | @variable = column { += | -= | *= | /= | %= | &= | ^= | |= } expression } [ ,...n ] [ OUTPUT Clause ] [ FROM{ table_source } [ ,...n ] ] [ WHERE { search_condition | { [ CURRENT OF { { [ GLOBAL ] cursor_name } | cursor_variable_name } ] } } ] [ OPTION ( query_hint [ ,...n ] ) ] [ ; ] object ::= { [ server_name . database_name . schema_name . | database_name .[ schema_name ] . | schema_name . ] table_or_view_name} |
Description
Cette instruction permet de modifier des données existantes dans une table ou un vue de la base de données.
Dernière mise à jour : Vendredi, le 19 Juin 2020