SQL Server 2008 MERGE Statement

Monday Sep 29th 2008 by DatabaseJournal.com Staff

This article introduces how the SQL Server 2008 MERGE statement can be used.

[From SQL Server Performance]

SQL Server 2008 introduces the MERGE statement which will allow users to perform insert, update and delete operations in a single statement. In the earlier versions of SQL Server to achieve the same functionality the database developer or database administrator needed to write separate statements to perform the insert, update or delete of data in one table based on certain conditions in another table.

The article continues at http://www.sql-server-performance.com/articles/per/SQL_Server_2008_MERGE_Statement_p1.aspx

Mobile Site | Full Site