RajasekharwhY / Build-your-muscle

Learning concepts and sample practice code - C#, MVC, SQL etc..
2 stars 0 forks source link

How to use merge option in sql when it is useful ? #25

Open RajasekharwhY opened 5 years ago

RajasekharwhY commented 5 years ago

If you want to update/insert/Delete the target table based on the source table matching condition, we can use merge option.

To update/Insert/Delete a target table based on the source table and the match condition we use Merge in sql server.