3.2. UPDATE
The SQL Server (Transact-SQL) UPDATE statement is used to update existing records in a table in a SQL Server database.
QUERY :- UPDATE tbname SET column1 = expression1 ,column2 = expression2, ….
WHERE condition;
EXAMPLE :- UPDATE employee SET f_name = ‘Sunil’ WHERE e_id = 1;
Description:-
Column1:- column name which you will update.
Expression1:- write the correct or updated value.
Last modified: Monday, 2 December 2019, 12:17 PM