This should be easy for anyone who's been following the discussion about part 1 of this question!

TomThomson (8/6/2014)if I want put many column names into for example a select list using an SP to generate a complete list (which I can then prune) is faster than...

I knew what the answer was going to be, so got it right.

But this method will only tell you if a column is (for instance) varchar. It doesn't tell you...

Only 75% correct answers so lots of people have learned something

sorry there was meant to be a smiley in there 😛

Yes very good.

Now, how about some actual documentation (from Microsoft), rather than some forum and blog posts that don't actually address the question but just assume the...

That's why I don't like the question. It came down to a test of whether...

SQL2014.

Statement...

Being pedantic, only 3 of those statements return syntax errors...

BWFC (7/7/2014)

---

I'm sure I'm missing something very basic here but I was under the impression that because there is no ordering automatically on a table, the row returned by TOP...

Had to guess whether it was a question about collation (no rows) or default data types (1 row), and luckily plumped for the right one 🙂

Given the discussions about collation over the years, I assumed that this was a "trick" question on that subject. In which case the correct answer would have been

Table Test is...

This.

BWFC (6/18/2014)

---

You may well...

You are working for a company that has uses SQL 2012 for their on site databases. A fellow DBA is trying to do a quick check on a database by...