Modifies a column's values in existing rows of a table or view. Restriction: You cannot use UPDATE on a table accessed via an engine that does not support UPDATE processing. You can update one or more ...

The first thing you need to ascertain is the version of SQL Server you are currently running and the most current update to your version. To check the version number for a running SQL Server database, ...