I suggest right the opposite.

Coming back to the question and the answers....

Where is the simularity between the queries?

Both return a single value (or an empty set).

Not...

Quite similar.

One query returns a constant and the other returns a...

OKAY similar test.

Q: Will the statement

SELECT 12345 AS AGE

return the same result as

SELECT TOP 1 Age FROM CUSTOMERS

?

Actually, the answer is A2, NO. Reason. There MAY BE a customer whose AGE is 110 or 111. The first query will catch that as the value...

The question did not ask you to assign it to 0. The reason the word "consistently" is in the question is because the author of the question realized that...

Lynn Pettis (6/9/2008)

---

Sorry, I can't agree with you.

One, I understood the question and what it was asking and therefore answered it correctly.

Two, I've been in IT long enough...

Lynn Pettis (6/9/2008)

---

I think people are making too much of the question. The real point of it wasn't the data used in the question but the BETWEEN clause itself....

AGAIN. The question makers should take some English language classes.

What sort of question is this:

Q: What happens?

A: The list of databases.

How can a "list of databases" happen?

The correct question should...

The question is correctly formed but the correct answer to the question is NOT DETERMINED. or whatever was the third one.

Any school kid knows that the RAND(?) function returns random...

etxeb (5/13/2008)

---

Hi,

I would like to know if there is a way to execute stored procedures every second. I have tried with jobs and the minimun execution schedule is every minute....

The explanation is incorrect.

First of all the LENGTH of the string representation of the months is EVEN, not ODD.

Second of all, the proposed method is NOT THE ONLY ONE...

[STRIPPED]

Susan Shafer (4/13/2008)

---

The query is defined in the DSVs. If you don't change anything it is a straight select from a table. Or you can change it and...

Jignesh Mehta (4/6/2008)

---

The question ask only for those employees Who joined in the month of Jan, Feb, March, April, May, Aug from table employee having a field of join_date where...