Brad McGehee hasn't just been sitting there on the top of this forum in the red band asking 'true/false' questions. He's just written a book for Simple-Talk called 'How to...

[p]You'd probably be able to use a scalar function here, to do this.[/p]

[font="Courier New"]SELECT

            ppl.FirstName,

            ppl.LastName,

            dbo.GetAge(ppl.BirthDate)

    FROM People AS ppl

            [/font]

I'm a card-carrying dyslexic. Real, genuine. I find any sort of simple-minded multiple-choice questionnaire that merely tests ones ability to remember facts to be extraordinarily difficult. Naturally, I failed the...

Ian, I have every sympathy for the Spaghetti-western approach to projects. My editorial was really about the extraordinary reluctance of companies and government to take the obvious step with a...

... and make sure there isn't a trigger on the table causing mischief

[p]I suspect that something like this would do the trick. I haven't tested it because I haven't the time to do the sample code![/p]

[font="Courier New"]

SELECT

[compound_id]=compound_ID,

[compound_name] =MAX(CASE WHEN name_Type=1...

In these postings on this forum, there have been quite a bit of confusion between the case-sensitivity of computer languages themselves and the various functions used for searching text.

The proponents...

As you know, Steve, I'm a 60's blues (and folk) guitar player, though now I tend to specialise in playing the Uke. Perhaps I ought to record some backing tracks...

[p] A simple test to put in your build scripts or stored procedures. As far as I know, the only way to heal this problem if it happens is to...

If Microsoft claim that they have lost interest in maintaining and developing SQL Server 2005, maybe we ought to suggest to them, with a straight face, that they...

I sometimes get the impression that the Beard-and-Sandals brigade are playing 'Grandmothers footsteps' with the industry over this whole issue. There seems to be a tireless 'stealth' operation to make...

As I understand it, Standard SQL converts identifiers to upper case internally unless they are delimited. IBM, Postgres, Sybase and Oracle follow this rule. What this effectively means that as...

A simple test of the daftness of the idea that case sensitivity in computer languages is a good idea is to read out a C# program that uses case to...

A while back, I decided to try writing a blog posting every week. It wasn't for a SQL Server site, but for an unrelated interest. Heaven only knows how Steve...

I spend a lot of time writing. I do it because it helps me to understand, and remember, the things I come across. I find that if I'm...