Thanks Barry,

But I don't get the explanation. The statement that immediately precedes the insert is a GO i.e. a batch separator. So we are not in the same...

Bonjour Frédéric,

Ca pourrait etre tres interessant comme projet - de traduire ton (tes) livre(s). Je sais pas si j'aurais le temps, par contre! Mais envoie-moi une message si...

Couldn't be more clear...well done!

Michael,

It sounds to me like a problem with the scope of the variables. They've got to be created with package level scope, otherwise they'll not be visible. The...

Sean Walker (5/2/2008)

---

Umm, it may be that my brain is fuzzy on a Fri morning, but isn't Select datename(m,'2008-07-12') = 'July' (in English) which I'm pretty sure doesn't have an...

Lots of different solutions.

The only one that won't always work is the answer given.

As a reader based in continental europe, I should point out the fact that if you're running...

Handy to know...I'm sure I'll be using that in my code very soon!

Well, they're not purely cosmetic. Specifically they enable you to write recursive queries - which I don't cover in this article. Recursion was much more difficult with SQL...

Why don't you read the previous posts 🙂

I can certainly see that having an index on ColA,ColB is completely different from an index on ColB, ColA.

(It's like having a phonebook sorted by First Name, Last Name and...

Very good overview article, Paul.

I'm glad to see I'm not the only one writing about this stuff.

http://www.sqlservercentral.com/Authors/Articles/David_McKinney/155294/

I look forward to seeing what else you come up with.

David McKinney.

Very good article.

I just think RBAR would catch on more, if it were pronounced AR-BAR. (Sorry 😉 )

Just a quick note to say thanks to everyone for all their feedback. My previous articles were about xml and xsl and while apparently appreciated, they didn't generate any...

Hi,

Hmmm.... You're not...

I haven't...