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.

Syntax:

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

Output:

SQL server update data 5

You can see that the above records are now updated.






Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


B.Tech / MCA