I got it right so I'm not complaining, but technically the alias can be defined by providing a column list as per answer 4, specifically:

WITH MonthlyProductSales (YearMonth, ProductID, SumLineTotal) AS

So...

I only raised it because I was expecting one of the sneaky gotcha type questions.

I know that User entries could be created for all of them, and immediately selected...

Time to complain about the question... (somebody always does)

A USER can be created for a certificate or asymmetric key, but they cannot Login:

Users that cannot authenticate These users cannot login...

I got it right because I use this type of query quite a lot, but I would argue that none of the queries will help you because they only return...

The explanation script is definitely wrong - it defines the columns as being numeric(17,0) i.e. 17 digits long and then tries to insert a 19 digit number, which obviously fails.

Change...

It says it very clearly here: http://msdn.microsoft.com/en-gb/library/ms188351.aspx

"Changes the name of a user-created object in the current database. This object can be a table, index, column, alias data type,...

I also don't see the trick, but even if "data" has been added properly it would (or should) still have given an error because "<a>1<c>3</c><d>4</d></a>" is not valid XML: <a>...

It is all very well saying "re-run it with this additional line" when the returned error from the code in the question is exactly the wording of one of the...

Another wrong coin flip...

I had never seen this option before so had to read it up which is great; it is the whole point of doing these questions - to...

I have to say that learning that a self-referencing Foreign Key doesn't prevent Truncate while interesting is probably not of that much practical value.

But I will say thanks for highlighting...

Well I assumed that the purpose of the question was to know that CREATE PROCEDURE has to be the first statement in a Batch and therefore the code as listed...

While I haven't tried them (have work to do) I am not convinced that any of them "work reliably" when you consider changes to and from daylight savings.

In...

A new one on me too, I would probably have ended up with really messy instr and substr or perhaps xpath functions to achieve the same.

There is an interesting example...