Not sure I like the sound of the "Bugger Pool Extnetion" as given in the answer!

Of course, in a case sensitive database, the answer is "none of the above".  table_a <> Table_a <> TABLE_A.

Of course, before it even gets that far, it will fail because of the missing quote at the start of the filename ;^{)}

I saw it, but I was doing some VBA yesterday,...

Thanks Steve, an interesting article, but it does rather contradict the order given in your answer.  You have FROM, ON, JOIN..., but in figure 4 in Ben-Gan's article it has...

My thoughts exactly (I came here to see if anyone had commented yet).  My assumption is that the ON is deciding what to join and how, and then the JOIN...

A nice easy one, made even easier by having "an" in the question rather than "a", which immediately eliminated half of the options.

edwardwill (3/18/2016)

I pasted the example into a query window and pressed F5

SELECT

TRY_CONVERT(VARCHAR(10),...

I didn't manage to get this to work using the "proper" WS task. Did get it working from a script task though, which worked a treat. I generated...

Had to flip a coin between first and second answer. The question just asks for what will decrypt the field - the first one does do this, it just...

That's my common experience too.

The other favourite is "this will be fixed in the next version", but we're already several versions...

Can someone explain how adding a NOEXEC statement and then having to remember to remove it again afterwards is "easier" than just pressing Ctrl-F5 in SSMS?

In a question like this...

As the design stands at the moment, it...