In SQL Server, what is the purpose of the MERGE statement?
A. Combine rows from two or more tables
B. Update, insert, or delete data based on a condition
C. Sort the result set
D. Join multiple tables
The MERGE statement is used to update, insert, or delete data based on a condition in SQL Server.