Merge Statements in T-SQL

Merge statements provide a flexible approach to manipulate data in a "target" table based on a join to a "source" table. The enable users to perform a large # of updates and/or inserts in a target table using a single T-SQL statement.

[keekee]

never deep on using merge T-SQL before and looks easy to implement and yield fast result with very straight instruction! thks a lot!

[jamiegreenwood]

Thanks Steve, the merge statement looks very useful.

[TripRide]

Great vid, really helps out in understanding. Thanks Steve!

[nagelfamily]

Eureka. It has been simplified! Walked through the sample.

[DJJSerpico]

Thank you, Steve. Took me 2 times to review, but I got it.

[janeyajaneya]

Hi Steve, one question here if we are doing a Merge with bulk data and if the update for one record fail then all the records after that will not be merged. How can we skip errorneous record.