FILTER

Question

FILTER

Viewing 3 posts - 31 through 32 (of 32 total)

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

Lokesh Vij SSChampion Points: 10836 More actions · Answer 1

Sean Lange (9/18/2012)
Nice back to basics question. I am astounded that at the time of my posting there are 111 (14%) that answered this wrong. I can understand those that answered 3 because they may have not known the default was case insensitive, but the ones that answered none is amazing. It seems we can't review the basics enough.
Well done Lokesh, looking forward to your next submission.

Thanks for the appreciation Sean. Even I winked my eyes looking at the numbers who marked "None" as the option :hehe:

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com[/url]

Follow me @Twitter

udayroy15 Ten Centuries Points: 1076 More actions · Answer 2

Good question.......

where main consideration is - The default collation setting for SQL Server is Case Insensitive

Scott Clark-275269 Ten Centuries Points: 1221 More actions · Answer 3

This was a tricky one especially for those of us who take these questions literally. As 6 would be the answer if the question was posted towards sql 2008+ versions none would be the answer in a pre-2008 environment due to the lack of support for multi-row inserts. So there are two valid answers to this question of the day "none" and "6".