March 28, 2016 at 11:51 pm
Comments posted to this topic are about the item Unique Constraints
March 29, 2016 at 12:28 am
Good question Peter. Thanks for sharing
March 29, 2016 at 3:37 am
Missed the "Distinct"
March 29, 2016 at 5:06 am
Nice, simple, straightforward question. I admit I'm surprised that only 55% of the respondents got it right so far.
March 29, 2016 at 7:02 am
Easy one thanks.
March 29, 2016 at 7:03 am
Jamsheer (3/29/2016)
Missed the "Distinct"
Yep, that'll get ya.
March 29, 2016 at 7:18 am
Thanks for a good explanation and an interesting reference link.
March 29, 2016 at 8:44 am
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
March 29, 2016 at 1:47 pm
Good reminder about trailing spaces.
Don Simpson
March 31, 2016 at 9:55 am
Looked up the differing length comparison before answering, still got it wrong, but for a silly reason. Learned something, so thank you
April 2, 2016 at 3:01 pm
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.
April 4, 2016 at 6:51 am
Great one, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 12 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy