T-SQL

Question

T-SQL

January 7, 2010 at 10:43 pm

This was removed by the editor as SPAM

Viewing 15 posts - 31 through 45 (of 47 total)

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

Steve Jones - Editor (1/7/2010)
I see both sides in this argument. BOL is inconsistent and I have added feedback to that note to various links to have this clarified at the source we use. When I got the QOD and followed the link, Predicate seemed correct. However the more I look at the wording, I can see where operator is a valid argument. My first thought was operator as well, but then I thought it's in the WHERE clause, so predicate made sense.
I have changed the question to include "in (z, y, z, ...)" as the "what is this" portion, which should clear up confusion as to this being a predicate.
I will award back all points to date to people once my password gets reset 🙂 Forgot it over the holidays. :hehe:

Thanks Steve.

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

Jeff Cook-476310 SSC Enthusiast Points: 114 More actions · Answer 2

Now it's even more confusing - the question has changed; the answer has changed from predicate to operator which I don't think is correct with the new question; and, the explanation still lists predicate as the correct answer!

Steve Jones - SSC Editor SSC Guru Points: 734418 More actions · Answer 3

the answer is predicate. It has not changed. The change from

"IN"

to

"columnX IN (x, y, z, ...)"

Makes it a predicate.

Jeff Cook-476310 SSC Enthusiast Points: 114 More actions · Answer 4

I'm not sure what is going on but when I went to http://www.sqlservercentral.com/questions/T-SQL/68500/

and answered predicate (to the revised question), the site said:

Sorry - you were wrong

Correct answer: Operator

Explanation: In T-SQL, a PREDICATE allows you to check whether a value or scalar expression evaluates to TRUE, FALSE, or UNKNOWN. The IN clause, with column and values becomes a predicate and checks to see if at least one of the elements in a set is equal to a given value or expression.

T-SQL PREDICATE: http://msdn.microsoft.com/en-us/library/ms189523%28SQL.90%29.aspx

Join the discussion about this question

Contribute a question of your own

Tom Garth SSCertifiable Points: 6193 More actions · Answer 5

Steve Jones - Editor (1/7/2010)
the answer is predicate. It has not changed. The change from
"IN"
to
"columnX IN (x, y, z, ...)"
Makes it a predicate.

Maybe you should check it again Steve. I checked Predicate less than 10 minutes ago and got it wrong.

Tom Garth
Vertical Solutions[/url]

"There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

thecosmictrickster@gmail.com SSChampion Points: 10386 More actions · Answer 6

Jeff Cook-476310 (1/7/2010)
I'm not sure what is going on but when I went to http://www.sqlservercentral.com/questions/T-SQL/68500/
and answered predicate (to the revised question), the site said:
Sorry - you were wrong
Correct answer: Operator
Explanation: In T-SQL, a PREDICATE allows you to check whether a value or scalar expression evaluates to TRUE, FALSE, or UNKNOWN. The IN clause, with column and values becomes a predicate and checks to see if at least one of the elements in a set is equal to a given value or expression.
T-SQL PREDICATE: http://msdn.microsoft.com/en-us/library/ms189523%28SQL.90%29.aspx
Join the discussion about this question
Contribute a question of your own

Ditto - I chose predicate. Even more confusing when I was reading through the comments (thinking "but IN isn't by itself - the whole statement will resolve to TRUE, FALSE or UNKNOWN") until I got to this post and realised the question had been altered - although not the answer it would appear.

Scott Duncan

MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare

Rick Townsend Ten Centuries Points: 1228 More actions · Answer 7

Scott Duncan-251680 (1/7/2010)
Jeff Cook-476310 (1/7/2010)
I'm not sure what is going on but when I went to http://www.sqlservercentral.com/questions/T-SQL/68500/
and answered predicate (to the revised question), the site said:
Sorry - you were wrong
Correct answer: Operator
Explanation: In T-SQL, a PREDICATE allows you to check whether a value or scalar expression evaluates to TRUE, FALSE, or UNKNOWN. The IN clause, with column and values becomes a predicate and checks to see if at least one of the elements in a set is equal to a given value or expression.
T-SQL PREDICATE: http://msdn.microsoft.com/en-us/library/ms189523%28SQL.90%29.aspx
Join the discussion about this question
Contribute a question of your own
Ditto - I chose predicate. Even more confusing when I was reading through the comments (thinking "but IN isn't by itself - the whole statement will resolve to TRUE, FALSE or UNKNOWN") until I got to this post and realised the question had been altered - although not the answer it would appear.

Same here - was a bit surprised to see Operator as the correct answer when it seemed Predicate was right. Then to be told in the explanation that predicate is correct left me completely confused. Glad to see that I'm not the only one!

Rick
townsends.ca

SSSolice SSCommitted Points: 1907 More actions · Answer 8

In light of all the confusion, I respectfully apologize to everyone for not making the question more clear in the first place.:blush:

Steve Jones - SSC Editor SSC Guru Points: 734418 More actions · Answer 9

Doh! It's fixed. I must have made a mistake when I changed the question.

It now shows predicate as the answer. I'll fix points.

Ron McCullough SSC Guru Points: 63877 More actions · Answer 10

SSSolice
In light of all the confusion, I respectfully apologize to everyone for not making the question more clear in the first place.

1. Do NOT take the belittling comments to heart

2. Do NOT feel bad

3 Do NOT stop submitting QODs...

Goodness knows I have been banged from pillar to post, hopefully you will have learned from this, (I take it this was your first QOD), and your next attempt will be composed keeping in mind all the nit picking that it might be subjected to.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

sjimmo SSChampion Points: 11139 More actions · Answer 11

Don't let anyone here intimidate you. Sometimes they forget that they too had to start someplace. It was a good question, just a bit of a formatting issue maybe.

Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan

Clive Chinery SSCrazy Points: 2563 More actions · Answer 12

According to ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_6tsql/html/edd92f08-76fb-4fd7-a4b6-8520d6a81df1.htm IN is an operator!

Christian Buettner-167247 SSChampion Points: 13729 More actions · Answer 13

SSSolice (1/7/2010)
In light of all the confusion, I respectfully apologize to everyone for not making the question more clear in the first place.:blush:

Well you posted a question and I thank you for entering the ring and offering your left & right cheek :-D.

And always remember - Only those who do nothing do not make mistakes

Best Regards,

Chris Büttner

Chris Hamam SSC-Addicted Points: 444 More actions · Answer 14

Christian Buettner-167247 (1/8/2010)
SSSolice (1/7/2010)
In light of all the confusion, I respectfully apologize to everyone for not making the question more clear in the first place.:blush:
Well you posted a question and I thank you for entering the ring and offering your left & right cheek :-D.
And always remember - Only those who do nothing do not make mistakes

hmmmm.... I think doing nothing is also a mistake....

For all that's required for evil to succeed in this world is for good men (like yourselves helping others here 😉 to do nothing!

--Chris Hamam

Life's a beach, then you DIE (Do It Eternally)