After the tables have been created and the data added, changing or updating data in the tables becomes one of the day-to-day processes in maintaining a database. SQL Server provides the following ways to change data in an existing table.
Describes the database application programming interfaces (APIs) that support options for updating data at the current position of a result set. Transact-SQL server cursors also support updating data at the current row of a cursor.