電子工常出社 53对已有数据进行管理 ·5.3.1修改数据信息 其语法如下: UPDATE t table_name WiTH(<table_hint_limited>[. nD VIew name rowset_function_limited y SET column_name expression DEFAULT NULL I @variable expression I@variable= column expression)l. n] R[FROM <<table_source>l.n]] TWHERE <Search_condition>11 I [WHERE CURRENT OF fiiGLOBAL] cursor_name cursor_variable_name]] [OPTION (<query_hint>L.])] 返回目录• 5.3.1修改数据信息 • 其语法如下： • 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] )] • 返回目录 5.3 对已有数据进行管理