Good question, if you read it carefully you will get the answer right.

Thanx

Steve Jones - SSC Editor (9/9/2014)

---

I do, in fact, understand the MERGE statement, but for some reason checked the wrong box when I was picking the answer. The question and...

It`s a typo I think, but still the answer is wrong!

Same here buddy & 93% did the same :w00t:

Another wrong answer 😎

According to BOL:

USING <table_source>

Specifies the data source that is matched with the data rows in target_table.

So in the question, table SalesAdjustments is the Source table not the target, I...

Thx.

But anyway it`s good question although I am using table aliases in the code structure more than synonyms.

In the question:

CREATE SYNONYM Emp

but in the explanation:

SELECT * FROM emp2

From where this emp2 came?!

stephen.long.1 (9/5/2014)

---

Nice question, Steve, but I agree with Tom, the answer is a little too obvious (central repository ==> centralized VCS). Still, I had never heard of these different types...

Easy mozo 🙂

Never liked long questions, they are just tedious & this one was too long 🙂

Me neither, though could guess it right 🙂

Nice question & nice function, thanx 4 the 7 pts. 🙂

Not easy 2 me, so had to do some R&D before answering, but it`s always good to learn new staff.