Yay! Thank the lord for Google 😀

Thanks happycat for the detailed explanation, makes perfect sense now.

Good question, I got it right but ultimately you could argue that they are all SQL Statements, especially "Direct Input".

Pedantic, I know 😛

"In 1492, Columbus sailed the ocean blue" . . . and made the first contact with the "Indians." For Native Americans, the world after 1492 would never be the same....

I also was caught out by the use of the word "great" which I interpreted as a "positive" performance impact.

Therefore considered the statement false as the impact is negative performance...

Toreador (6/24/2010)

---

A good idea, but a bit too easy to guess! Even though I failed to come up with an example, I got it right as the obvious answer was...

Again, looking for a trick in the question, as again the answer seemed too easy.

As temp tables are dropped at the end of the session, I assumed this is what...

Aargh!! Again my initial reaction was "that's easy it's 5,2,2 as LEN ignores spaces"... and then "hmmm, but that's too easy, there must be a trick in there"... and after...

Read the question correctly, assumed a cropped NULL... come on! people, stop being pedantic!!

Still got it wrong, knew the correct answer but, through a lack of confidence, suspected a trick...

My hobby is/was Mountain Biking, preferably deep in the mountains where signs of society are few and far between. It's my escape and since the wee man arrived I don't...

Good question that in its simplicity makes you question what seems the obvious answer and think about it more deeply.

According to SQL Books Online, the parser actually checks all conditions...

You know what... you guys are right.

It's just took me less than a minute to work out he was just setting the hour to 10:30 and 12:00 respectively, and then...

I have to agree with Hugo here, if the question is overly complicated involving long "unreadable" calculations, then it's going to send most people I would imagine down the path...