Javatpoint Logo
Javatpoint Logo

SQL Server Update Data

In SQL Server database, UPDATE statement is used to update or modify the already inserted records into a table.


Use the SQL Server management Studio:

Follow the management studio screenshots given below:

SQL server update data 1

After clicking on "New Query Editor Window", you will see the following query page.

SQL server update data 2

Use the following command:

SQL server update data 3

You can see that 1 row is affected. You can verify it:

SQL server update data 4


SQL server update data 5

You can see that the above records are now updated.

Youtube For Videos Join Our Youtube Channel: Join Now

Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Trending Technologies

B.Tech / MCA