Hi,

I'm struggling to think of a year when it wasn't April 1st.

Joking aside, can you clarify what you need here? Is it April...

I get that too. Perhaps it's because I'm in the UK.

Morning,

Your code does not look like SQL Server as there is no TIMEDIFF function here. Is this an exercise for MySQL?

If you need a practice one you can try TranscriptID 1070318 with Access Code R1chardW.

Congratulations Simon! Hope they appreciate your achievement in the office.

Thanks, and good luck with 463. As a developer I'd classified these as:

461 - The (should be) easy one

462 - The hard one

463 - The interesting one

...but I expect they're...

Passed it this time 🙂

Now on to 461.......

Hi Jacky,

To prevent any confusion does 8/1/2009 mean 8th January or August 1st? And what do the two current fields look like? ('1','01','Jan' etc.)?

Thanks for the above info on 70-461 - sounds like it's a lot harder than the practice tests! I therefore decided to bash on with taking 70-462 again first (again...

You get a point for comlaining...

The answer is correct. It's the question that's wrong. I'm sure the question should be "Which DO NOT require WITH" in which case everything falls into place.

Best one for keys is the 2003/04 Nissan Micra.

From http://www.honestjohn.co.uk/carbycar/nissan/micra-k12-2003/

Early Micra K12s with 'intelligent keys' are becoming economic write-offs because when the system fails a new steering column...

Hugo Kornelis (3/14/2013)

Locale settings.

Contrary to popular belief, yyyy-mm-dd hh:mm:ss and yyyy-mm-dd are NOT a guaranteed...

Interestingly, if I run the code, I get:

Msg 242, Level 16, State 3, Line 1

The conversion of a varchar data type to a datetime data type resulted in an out-of-range...

Thank you. To be honest, not a lot in this...