April 27, 2011

Update statement joining two table in SQL Server

UPDATE Table1
SET
Field = Table2.Field
FROM
Table2
WHERE
Table1.Field = Table2.Field

* Where Field is common domain field in both table.

No comments:

Post a Comment