SQL Server Transact Basic to Expert - Update Query

This blog shows how to use the Update statement. Update statement is used to update a data to a existing available row in a table.

Syntax:

Update Table
Set Column1 = '', Column2=''
Where Condition

Example:

Update emptable
Set empname = 'Karthik Anbu'
Where empid = '1'