xxxxxxxxxx
--the simplest way of doing this
UPDATE
table_to_update,
table_info
SET
table_to_update.col1 = table_info.col1,
table_to_update.col2 = table_info.col2
WHERE
table_to_update.ID = table_info.ID
xxxxxxxxxx
UPDATE YourTable
SET Col1 = OtherTable.Col1,
Col2 = OtherTable.Col2
FROM (
SELECT ID, Col1, Col2
FROM other_table) AS OtherTable
WHERE
OtherTable.ID = YourTable.ID
xxxxxxxxxx
--update query example
UPDATE table_name
SET column1 = value1, column2 = value2,
WHERE condition;
xxxxxxxxxx
UPDATE table1
SET column2 = 'Your Text', column3 = 45000
WHERE column1=5
xxxxxxxxxx
UPDATE your_table_name
SET column1 = select_statement.column1,
column2 = select_statement.column2
FROM (
SELECT column1, column2
FROM another_table
-- Optional: Add JOIN or WHERE conditions to filter/select specific records
) AS select_statement
WHERE your_table_name.id = select_statement.id;
xxxxxxxxxx
UPDATE your_table
SET column1 = new_value1,
column2 = new_value2,
FROM (
SELECT column_to_update, value
FROM another_table
WHERE some_condition
) AS subquery
WHERE your_table.join_column = subquery.join_column;
xxxxxxxxxx
Update salesTransaction
Set Unit_Price=45.41,Item_Number='Milk-1'
Where trx_id=1249
xxxxxxxxxx
UPDATE Table_A SET Table_A.col1 = Table_B.col1, Table_A.col2 = Table_B.col2 FROM Some_Table AS Table_A INNER JOIN Other_Table AS Table_B ON Table_A.id = Table_B.id WHERE Table_A.col3 = 'cool'
xxxxxxxxxx
In SQL Server 2008 (or newer), use MERGE
MERGE INTO YourTable T
USING other_table S
ON T.id = S.id
AND S.tsql = 'cool'
WHEN MATCHED THEN
UPDATE
SET col1 = S.col1,
col2 = S.col2;
Alternatively:
MERGE INTO YourTable T
USING (
SELECT id, col1, col2
FROM other_table
WHERE tsql = 'cool'
) S
ON T.id = S.id
WHEN MATCHED THEN
UPDATE
SET col1 = S.col1,
col2 = S.col2;