sql

Question

syntax of using both insert and update in a single query

Jignesh Trivedi · Answer

HI MERGE is a new feature that provides an efficient way to perform multiple DML operations. In previous versions of SQL Server we had to write separate statements to INSERT UPDATE or DELETE data based on certain conditions. MERGE [AS TARGET] USING [AS SOURCE] ON [WHEN MATCHED THEN ] [WHEN NOT MATCHED [BY TARGET] THEN ] [WHEN NOT MATCHED BY SOURCE THEN ]; please refer http://weblogs.sqlteam.com/peterl/archive/2007/09/20/Example-of-MERGE-in-SQL-Server-2008.aspx http://www.codeproject.com/Articles/37172/Merge-Statement-in-SQL-Server-2008 hope this help.