Using SQL Server 2008’s MERGE statement

(Tim Chapman) SQL Server 2008’s new MERGE statement allows you to insert, update, or delete data based on certain join conditions in the same statement. In previous versions of SQL Server, you have to create separate statements if you need to insert, update, or delete data in one table based on cert

Read More - Register for Free Membership