Unique Constraints

Question

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

Umer Akram SSC-Insane Points: 22209 More actions · Answer 1

SSC-Insane

Points: 22209

March 29, 2016 at 12:28 am

Good question Peter. Thanks for sharing

Jamsheer Ten Centuries Points: 1136 More actions · Answer 2

Ten Centuries

Points: 1136

March 29, 2016 at 3:37 am

Missed the "Distinct" 😛

Ed Wagner SSC Guru Points: 287026 More actions · Answer 3

Nice, simple, straightforward question. I admit I'm surprised that only 55% of the respondents got it right so far.

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 4

SSC Guru

Points: 76202

March 29, 2016 at 7:02 am

Easy one thanks.

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 5

Jamsheer (3/29/2016)
Missed the "Distinct" 😛

Yep, that'll get ya.

George Vobr SSCrazy Eights Points: 9996 More actions · Answer 6

Thanks for a good explanation and an interesting reference link.

webrunner SSC-Dedicated Points: 31862 More actions · Answer 7

Thanks for the question. I learned something!

- webrunner

-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

DonlSimpson SSCertifiable Points: 7043 More actions · Answer 8

Good reminder about trailing spaces.

Don Simpson

I'm not sure about Heisenberg.

Joe O'Connor SSC Eights! Points: 904 More actions · Answer 9

Looked up the differing length comparison before answering, still got it wrong, but for a silly reason. Learned something, so thank you 🙂

patricklambin SSCrazy Eights Points: 9994 More actions · Answer 10

Interesting question about which I had to think during 10 minutes , searching where the trick was.

Amusing the link given towards an article from the old time of SQL Server 2000.

Thanks for this 1 point I got.

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 11

Great one, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP