#update statement

[aicorr]

SQL Update - AICorr.com

SQL Update. The term SQL stands for structured query language. SQL is a standard programming language, which focuses on processing..

[saianudeep]

Update Statement in Sql Server

Updating records in one table based on values in another table:

You may wish to update records in one table based on values in another table. Since you can't list more than one table in the UPDATE statement, you can do a join. You dont want to use EXISTS clause as shown at the end which is wrong way of doing it.

This is the way to do it

UPDATE suppliers SET supplier_name = t2.name FROM suppliers t1 JOIN customers t2 on t1.supplier_id = t2.customer_id

I saw in here http://www.techonthenet.com/sql/update.php they use EXISTS clause which shouldn't be practiced

DONT do this:

UPDATE suppliers SET supplier_name =( SELECT customers.name FROM customers WHERE customers.customer_id = suppliers.supplier_id) WHERE EXISTS   ( SELECT customers.name     FROM customers     WHERE customers.customer_id = suppliers.supplier_id)

Whenever a supplier_id matched a customer_id value, the supplier_name would be overwritten to the customer name from the customers table.