MERGE to make Target match Source
Note: The AND NOT EXISTS portion prevents updating records that haven't changed. Using the INTERSECT construct allows nullable columns to be compared without special handling.
In this page (written and validated by A. Gawali) you learned about SQLServer MERGE . What's Next? If you are interested in completing SQLServer tutorial, your next topic will be learning about: SQLServer cross apply outer apply.