TeraByteMe (5/9/2013)

---

Hello All,

I was prescreened for a Senior SQL Program Analyst position and one of the questions asked is shown below. I have been around SQL quite a while but this question doesn't make sense to me. Can anyone help me decipher and understand what the correct answer is and how you got to it? I know this isn't a interview question/answer forum but the subject matter is definitely T-SQL and the correct use of it.

6. Field f of a table is indexed. Which of the following query fragments is written so the index cannot be used? (Assume p1 and p2 are the correct data types for their role in each fragment.)

a. where f > :p1

b. where f between :p1 and dateadd( day, :p2, :p1)

c. where dateadd( day, :p2 , f) > :p1

d. where dateadd( day, :p2, :p1) < f

e. where f not in( select …)

Thanks