Export (0) Print
Expand All
0 out of 3 rated this helpful - Rate this topic

Updating Data in a Table

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.

Changing Data by Using UPDATE

Describes how to use the UPDATE statement to update data in specific rows in a table or view.

Changing Data by Using a Cursor

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.

Changing ntext, text or image Data

Describes how to use the UPDATETEXT statement to update specific ntext, text, and image values.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.