Inside SQL Server 2008: Figure 4: Update and Insert Data with One Statement.

The MERGE statement lets you insert, update, and delete data in a table with a single statement. The results shown here show the contents of the Dogs table before merging data, the contents of the Inserted and Deleted tables, and the new contents of Dogs.

Inside SQL Server 2008: Figure 4: Update and Insert Data with One Statement.
comments powered by Disqus
Most   Popular
Upcoming Events

.NET Insight

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.