Great questions thanks!

I got it correct, but not for the right reason. 🙂

Wow, all that date math made me think... But the division part was easy.

Thanks for the question!

I almost picked "It Depends" because, but I thought no, it couldn't be possible with a standard VARCHAR. Learned another thing today, at the cost of a point. 🙂

Good question, thanks!

I'm actually a little surprised that most people got it correct. 🙂

Thanks, learned another thing today!

I think I wouldn't hire anybody that wrote code like that. Using * at all is bad enough. 😉

Another great question, I had to think about this one, but it makes sense. Thanks!

Thanks for the great question! I am learning so much more from these questions and their explanations.

Wow, I happened to be the first to answer it, and I got it right. 🙂

Though not for the reason you stated, as it makes no difference if ANSI_NULLS is...

I got it wrong but I learned a little more about XML, so not entirely a bad thing...

Good question, it made me think some. I did refer back to the previous similar question to see what was different, which helped.

One of the advantages of using EXISTS over the LEFT JOIN/NULL check is that it can't introduce a cartesian, and I think as a result of that the query optimize...

Since I was already logging the errors to a table I created a second SP that retrieves the last error for the user, and then modified the Access application to...

gregory.anderson (5/18/2010)Should I do a Left Outer Join then on my destination table and then just check to make sure that the common field in both tables is blank (null)...

elutin (5/15/2010)

---

How you call your SP from Access?

From SQL Server prospective, it is expected behaviour. The error is raised, query/sp execution stopped (conversion error will terminate your query or sp),...