This is something normally handled on the client, as was already said. But, you could use a CLR query to do it. I wouldn't recommend it, but it is possible....

That's actually...

mhaskins (7/18/2008)

Mine too - I don't know if my minimum wage customer service jobs were really...

This reminds me of when i started at my current company. I started the same day as another guy in my group. He was considered the people person/manager in the...

This is a good article. I can see why it was reprinted. I'd like to see an update. Things are just a little different in 2005/2008. Those differences, some of...

INCLUDE columns absolutely help with lookup...

Soft skills... Soft skills....

OH! I know. That's when you use wrist locks and grapple into submission holds rather than smash their face flat and kick their naughty bits up between...

And the functionality has improved a ton. I love being able to pull execution plans right off the screen.

I'm happy to see someone else come out with the old data saw, only move the data you need and only when you need it. I would have added that.

As...

Actually, if I were doing it, first, I'd try to avoid dynamic sql unless you use sp_executesql and pass it parameters (this creates execution plans that are reusable). For what...

Between the query window in Management Studio and the command line options available through sqlcmd.exe, anything you can do with isql.exe is very old hat indeed. They're either just using...

There probably is a vanishingly small performance hit for that, yes. However, all the other issues around writing are so intensive, that little tiny blip where the query engine rearranges...

That's not against what I said at all. That's what I've been trying to suggest. Thanks for stating it in a different way.

When data changed, a given row would be versioned, but not all rows or all tables. Also, the "version" was not a moment-by-moment creation. They would work on a given...

Maybe I'm old fashioned (or just old), but I've always felt that one of the principal duties you have is supporting those around you to the best of your ability....