MERGE Statement in SQL Server

Question

I want to know what is MERGE statement in SQL Server. Thank you.

Jignesh Trivedi · Answer

Hi Merge enable us to performs insert update or delete operations on a target table based on the results of a join with a source table. In other word it provides an efficient way to perform multiple DML operations base on condition. please refer http://technet.microsoft.com/en-us/library/bb510625.aspx http://www.mssqltips.com/sqlservertip/1704/using-merge-in-sql-server-to-insert-update-and-delete-at-the-same-time/ hope this will help you.

Vikrant More · Answer

Hi here is the article i found which helps you to know what is MERGE Statement in SQL Server. http://blog.sqlauthority.com/2008/08/28/sql-server-2008-introduction-to-merge-statement-one-statement-for-insert-update-delete/

Rahul Bhatt · Answer

Use + symobol to merge two field make your query as following way select CAST(FieldName1 as varchar)+' - ' + CAST(FieldName2 as varchar) from TableName

Satyapriya Nayak · Answer

Hi Vipendra Please refer the below links blog.sqlauthority.com/2008/08/28/sql-server-2008-introduction-to-merge-statement-one-statement-for-insert-update-delete/ www.mssqltips.com/sqlservertip/1704/using-merge-in-sql-server-to-insert-update-and-delete-at-the-same-time/ www.codeproject.com/Articles/37172/Merge-Statement-in-SQL-Server-2008 www.simple-talk.com/sql/learn-sql-server/the-merge-statement-in-sql-server-2008/ Thanks