SQL UPDATE Statement
This staement of update by Sql
Sql update where
Syntax: UPDATE Table Set fied1= Value1 , field2= Value2, … WHERE Emplid =’Test’;
UPDATE table_name
SET column1 = value1, column2 = value2, …
WHERE condition;
For Example:
Update Table Set Name=’Dakdee’ Where Emplid =’TT005′;
Update Table Set Name=’Dakdee’, LastName=’Toodd’ Where Emplid =’TT005′;
Sql update from select
Update TableName a set(a.column1, a.column2,a…) = (select column1, column2,… from tablename b where b.key = a.key) where exists (select ‘X’ from tablename b where b.key = a.key)
Sql update with join
Example 1
UPDATE tablename1
INNER JOIN tablename2 ON tablename1.value = tablename2.DESCR
SET tablename1.value = tablename2.IDKEY
WHERE tablename1.IDCODE=’XX’;
Example 2
UPDATE Person
SET
Person.PersonCityName=Address.City,
Person.PersonPostCode=Addrrss.PostCode
FROM Persons Person
INNER JOIN
Address Addrress
ON Person.Id = Addrrss.Id
If you want update muticolumn by sql then read more update select sql example.