Merge Statement Question.
Hi guys i have a doubt in one question i encountered while reading sql dumps.
Question:
Which tree are true?
a.A merge statement is used to merge the data of one table with data from another.
b.a merge statmement replaces the data of one table with that of another.
c.a merge statmement can be used to insert new rows into a table.
d.a merge statement can be used to update existing rows in a table.
Correct answer was given as a ,b and c.
i m very much certain about a,b,c and it seems like all are correct.
i think a merge statement can be used to update existing rows in a table as it normally does if the row exist in table.
then why they have not included d in the answer.
Please help with your advice.
I also have one more forum related question:How do i find my previous threads(The one i posted earlier).