Good thing this wasn't a pop quiz on the difference between "your" and "you're".

You could potentially miss out on some great employees if you let your ego get in the way of making an objective hiring decision. I've been working with T-SQL for...

So would you consider this a valid answer? "I think it's CURRENT TIMESTAMP but if I was blanking on...

Justin, if it helps, I never use "pop quiz" questions when I interview because I find that they don't give me enough information about a candidate's experience or ability to...

I saw you mentioned that, but I would have had to Google whether an update trigger fires once per update or once per row.

For #3, I'd have to Google whether or not an update inside an update trigger would cause an infinite loop. I don't know that off the top of my head...

Number 2 is selecting names of employees over 60. Or specifically, people who were 60 years old by the end of last year, since this is only comparing by year....

Aha! I knew there had to be something I was missing. So now to answer the OPs question, did most interviewees give you the same response I gave? Or were...

Ok, well in question 1, it looks to me like all 4 would return the same result, but I didn't test it! Putting a predicate on the ON clause should...

What are the answers?