UPDATE Statement in SQL Server

UPDATE Statement in SQL Server

In tis post, The UPDATE statement is used to modify or changes the existing records in a table

Syntax UPDATE

UPDATE table_name
SET column1 = value1, column2 = value2, column3 = value3, ...
WHERE condition

Example:

UPDATE Customers
SET CName = 'Manoj', City= 'Delhi'
WHERE CID = 100

2020-03-28