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:
After clicking on "New Query Editor Window", you will see the following query page.
Use the following command:
You can see that 1 row is affected. You can verify it:
You can see that the above records are now updated.