数据库中update语句.docVIP

数据库中update语句 篇一：sql的update语句功能非常强大 语法 UPDATE { table_name WITH ( lt; table_hint_limited gt; [ ...n ] ) | view_name | rowset_function_limited } SET { column_name = { expression | DEFAULT | NULL } | @variable = expression | @variable = column = expression } [ ,...n ] { { [ FROM { lt; table_source gt; } [ ,...n ] ] [ WHERE lt; search_condition gt; ] } | [ WHERE CURRENT OF { { [ GLOBAL ] cursor_name } | cursor_variable_name } ] } [ OPTION ( lt; query_hint gt; [ ,...n ] ) ] lt; table_source gt; ::= table_name [ [ AS ] table_alias ] [ WITH ( lt; table_hint gt; [ ,...n ] ) ] | view_name [ [ AS ] table_alias ] | rowset_function [ [ AS ] table_alias ] | derived_table [ AS ] table_alias [ ( column_alias [ ,...n ] ) ] | lt; joined_table gt; lt; joined_table gt; ::= lt; table_source gt; lt; join_type gt; lt; table_source gt; ON lt; search_condition gt; | lt; table_source gt; CROSS JOIN lt; table_source gt; | lt; joined_table gt; lt; join_type gt; ::= [ INNER | { { LEFT | RIGHT | FULL } [OUTER] } ] [ lt; join_hint gt; ] JOIN lt; table_hint_limited gt; ::= { FASTFIRSTROW | HOLDLOCK | PAGLOCK | READCOMMITTED | REPEATABLEREAD | ROWLOCK | SERIALIZABLE | TABLOCK | TABLOCKX | UPDLOCK } lt; table_hint gt; ::= { INDEX ( index_val [ ,...n ] ) | FASTFIRSTROW | HOLDLOCK | NOLOCK | PAGLOCK | READCOMMITTED | READPAST | READUNCOMMITTED | REPEATABLEREAD | ROWLOCK | SERIALIZABLE | TABLOCK | TABLOCKX | UPDLOCK } lt; query_hint gt; ::= { { HASH | ORDER } GROUP | { CONCAT | HASH | MERGE } UNION | {LOOP | MERGE | HASH } JOIN | FAST number_rows | FORCE ORDER | MAXDOP | ROB(来自:WWBothW 博威 范文 网:数据库中update语句)UST PLAN | KEEP PLAN } 参数 table_name 需要更新的表的名称。如果该表不在当前服务器或数据库中，或不为 当前用户所有，这个名称可用链接服务器、数据库和所有者名称来限 定。 WITH ( lt; table_hint_limited gt; [ ...n ] ) 指定目标表所允许的一个或多个表提示。需要有 WITH 关键字和 圆括号。不允许有 READPAST、NOLOCK 和 READUNCOMMITTED。有 关表提示的信息，请参见 FROM。 view_name 要更新的视图的名称。通过 view_name 来引用的视图必须是可 更新的。用