Good question for testing the basics, however the author was definitely being sneaky with the reversed assignment. If the intention was to truly test people's understanding of BETWEEN and DATETIME,...

Great question, but I got it wrong because I jumped too quick and didn't properly think it through.

I deliberately chose 1222 because it "Returns the resources and types of locks...

Thanks for the great question, learning something new everyday and today is no exception 😀

Great question, reminds me of the old logical puzzle exams in interviews.

Cheers 😀

Nice, straight forward, implicit conversion question. Greast start to the day.

Cheers 😀

Interesting question, and something definitely to be aware of.

Thanks

Ah! an assumption... he he! not so clear then 😉

Shark Energy (7/29/2011)

---

No excuses people I mean if follow the question in your head, it fails before you get to installing any SPx so follow the question and its all...

I don't mind so much getting this one wrong, as I have learnt a lot along the way, and had a very interesting time trying to find the answer.

However, I...

Sweet! Another nice and simple one answered in seconds, keep them coming 😀

Great question, thanks.

It doesn't get any easier than that, didn't even have time to think before my finger clicked the right answer 😀

Great question, and an easy point. Just how I like it 😀

I think it is fairly apparent that the author made a typo in the first select statement, and meant to have ModelID rather than just ID.

Never the less, I answered...

To quote Bulldog...

"Where the hell's my point? Somebody stole my point! This stinks! This is total BS! This is... oh, here it is."

Can I have my point please? pretty please?...

Great question.

I first thought 47, but the 18 in the answers made me hesitate, then the calculation for 18 simply led me back to the insert statement and the UNION...