Thanks for the question.

Got it wrong, and I even ran a test. Code below:

CREATE TABLE #Temp(Col1 INT NOT NULL

CONSTRAINT PK_QOTD_1 PRIMARY KEY (Col1))

INSERT #Temp(Col1) VALUES (1)

INSERT #Temp(Col1) VALUES (1)

INSERT #Temp(Col1) VALUES (2)

GO

SELECT * FROM #Temp

(not exactly the same code as the question, but functionally equivalent) Only got one row back from SELECT, as I had anticipated.

So, what have I got wrong here?