Cheap Californian Rosé Wine.

(Fits better with Medic that medic fitted with Haut Medoc)

I don't prefer one to the other,...

Maybe. If your login's default language is British it...

Almost a nice question, but actually not correct. The assumption that the server default language is us_english isn't adequate; you have to assume that the default language for the...

'Thanks for pointing that out. I've fixed the quote tags in that message, so it should now be clear who wrote what.

Because...

Saint Emilion

I'm sticking to my claret.

Hugo Kornelis (9/12/2013)[h]

It would be silly if I had actually written that. I haven't. What I wrote, multiple times in a (for me) short message, is that I had not...

Reading through the old comments on this topic, I was amused by some of the discussion about what being the man who saved the world (as opposed to the man...

That's...

ChrisM@Work (9/12/2013)

---

Your initialisation code fails with an error. Your expectations are incorrect.

I think this is what you are looking for:

CREATE TABLE #table1(c nvarchar(1));

CREATE TABLE #table2(c nvarchar(1));

INSERT INTO #table1 SELECT '1'...

Sean Lange (9/12/2013)

---

I agree Jack. Right joins are really difficult to wrap your brain around most of the time. I also tend to flip the tables around so it can...

Because we know that many of the really great people in computing/IT/database had not a single academic qualification in computing...

First, give each individual who needs sysadmin access through SQL login (ie can't reasonably use an NT login for it) a separate SQL login on each instance on each server,...

Oddly enough, SQL is a language that contains expressions.

It might have been useful is you had specified which language you were talking about in your first post.

Nice question, but it seems odd to refer to the SQL 2005 version of the BOL page for command, when there are perfectly good versions for the three releases currently...