IN or OR

Question

IN or OR

behera.prasanta

Mr or Mrs. 500

Points: 521
More actions
November 1, 2014 at 4:44 pm

#312594

Comments posted to this topic are about the item IN or OR
November 3, 2014 at 1:19 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 27 total)

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

webrunner SSC-Dedicated Points: 31882 More actions · Answer 1

Thanks for the question. However, something about the list of radio button options made me think the only option worth picking was that the queries give the same result, which happened to be correct.

Maybe checkboxes would have made it harder?

Just mt two cents. Thanks again.

- 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

Hany Helmy SSChampion Points: 13921 More actions · Answer 2

Eazy.

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

I appreciate the question. I seldom, if ever, think to perform the query in the second fashion.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

DrKiller Right there with Babe Points: 780 More actions · Answer 4

SQLRNNR (11/2/2014)
I appreciate the question. I seldom, if ever, think to perform the query in the second fashion.

+1, didn't really know its possible (well just never thought of it)

Are there any performance concerns of the second query though?

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

DrKiller (11/2/2014)
SQLRNNR (11/2/2014)
I appreciate the question. I seldom, if ever, think to perform the query in the second fashion.
+1, didn't really know its possible (well just never thought of it)
Are there any performance concerns of the second query though?

They both produce the same execution plan.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

uravindarreddy Ten Centuries Points: 1390 More actions · Answer 6

uravindarreddy

Ten Centuries

Points: 1390

November 3, 2014 at 2:29 am

#1756273

+1.

Really a nice question.

Victor Kirkpatrick Hall of Fame Points: 3672 More actions · Answer 7

Excellent question. Never really thought about using option 2 before now.

SqlMel SSCrazy Points: 2901 More actions · Answer 8

SqlMel

SSCrazy

Points: 2901

November 3, 2014 at 5:23 am

#1756299

Good question, Thanks.

---------------
Mel. 😎

behera.prasanta Mr or Mrs. 500 Points: 521 More actions · Answer 9

Both Statements have same performance and execution plan

cgumprich Ten Centuries Points: 1056 More actions · Answer 10

I learned something, so that makes it a good question, but to echo other concerns -- because of the radio buttons there was only one possible answer.

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 11

Seemed like both would return the same results. I just never use version two.

ronmoses@gmail.com SSCarpal Tunnel Points: 4480 More actions · Answer 12

Yes, I agree this seemed fairly obvious, but the fact that there are three correct answers (the first three options are all true) and I'm only permitted to choose one of them led me to conclude it must be none of those, since it could not be all of those. Not a well-designed question at all.

-----
a haiku...

NULL is not zero
NULL is not an empty string
NULL is the unknown

Aleksl-294755 Hall of Fame Points: 3514 More actions · Answer 13

Good question. Never thought about using the second option. I learned something. Thanks!