January 7, 2010 at 1:04 pm
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!
January 7, 2010 at 1:10 pm
the answer is predicate. It has not changed. The change from
"IN"
to
"columnX IN (x, y, z, ...)"
Makes it a predicate.
January 7, 2010 at 1:21 pm
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
January 7, 2010 at 1:36 pm
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.
January 7, 2010 at 2:35 pm
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.
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
January 7, 2010 at 2:56 pm
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
January 7, 2010 at 3:05 pm
In light of all the confusion, I respectfully apologize to everyone for not making the question more clear in the first place.:blush:
January 7, 2010 at 3:32 pm
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.
January 7, 2010 at 6:06 pm
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.
January 7, 2010 at 6:32 pm
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
January 7, 2010 at 8:28 pm
According to ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_6tsql/html/edd92f08-76fb-4fd7-a4b6-8520d6a81df1.htm IN is an operator!
January 8, 2010 at 1:05 am
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
January 8, 2010 at 1:12 am
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)
January 8, 2010 at 7:39 am
Steve Jones - Editor (1/7/2010)
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.
Steve, thanks for fixing the points but on the Total Scores page (http://www.sqlservercentral.com/TotalScores) I only see it fixed on the Question of the Day Breakdown table in the Points (won) column. The Score column on the Question of the Day table does not show the correction. You may need to fix it in both places.
Blast that de-normalized data! ๐
Dave
March 16, 2010 at 2:04 pm
I got lucky...
I saw IN, clicked operator, hit submit and immediately hit stop on the browser as I saw the Predicate answer.
You may deduct a point if necessary for changing my answer. I throw myself on the mercy of the forum... ๐
I really DO need to read the whole list of answers more carefully...
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
Viewing 15 posts - 31 through 45 (of 46 total)
You must be logged in to reply to this topic. Login to reply