语法:
[ with [...n] ]
update
[ top (expression) [ percent ] ]
{ { table_alias | | rowset_function_limited
[ with ( [ ...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 ]
[ ]
[ from { } [ ,...n ] ]
[ where {
| { [ current of
{ { [ global ] cursor_name }
| cursor_variable_name
}
]
}
}
]
[ option ( [ ,...n ] ) ]
[ ; ]
::=
{
[ server_name . database_name . schema_name .
| database_name .[ schema_name ] .
| schema_name .
]
table_or_view_name}
实例 php教程
利用update 更新数据
http://www.bkjia.com/phpjc/630745.htmlwww.bkjia.comtruehttp://www.bkjia.com/phpjc/630745.htmltecharticlesql update记录更新详细实例 语法: [ with common_table_expression [...n] ] update [ top (expression) [ percent ] ] { { table_alias | object | rowset_function_limited [ with...