Update a table data using SQL server :-

To update an existing Table we use SQL Command UPDATE: It will update the records as per user defined query/need.

Syntax:

Update TableName SET ColumnName = NewData where Condition

Ex:-

Update info Set City = 'Baroda' where id = 2