NBSteve (5/28/2013)

---

Interestingly, while the answer does hold for 2005+, for us dinosaurs who still have a few SQL Server 2000 systems, it throws a parse time syntax error on the...

Great question, thanks! I didn't know about any "variations" of the top statement. Learned something new today.

This is very true. I may not be able to provide a correct answer to a theoretical question that has nothing to do with the job I am being...

The interview process has gotten to be incredibly difficult. I know someone who has great skills, 17 years of experience in top financial companies, great work ethics. So...

Great question! I was pretty sure that it would work, but decided to run it anyway. It was a good idea to specify server version because, when I...

I have been in the field for a long time and have solved a lot of real life "puzzles". However, on a recent interview I was asked to solve...

Very interesting question. Thank you!

The question was very good! I almost answered it wrong because I thought it was left outer join instead of FULL outer join. For some reason the explanation...

Hugo, thank you for your explanation. I was totally confused by the square brackets.

Great question! Now that I know how "liberal" is numeric is, I will be more careful with it.

Thanks!!!

This is a very good question. My initial choice was 3/38. It's a good thing I decided to run the code before answering. I learned something new...

Finally an easy question!:-D Thank you very much!

I am not a DBA. I am a ColdFusion/SQL Server developer. I spend most of my time developing web applications. My job requiers a pretty strong knowledge...

Odly enough, when i ran the code I got '1234' as a result...

Useful tip. Thanks!