Wasn't that covered in the Old_MacDonald() Function? Or was that the Flying_Monkeys() I'm thinking of?

Sorry...couldn't help it. 🙂

Has anyone come up with something that can 'really' tell if a field value is numeric for all of the current sql-server data types?

My original beef with isNumeric() was the...

Jeff,

Thanks for illuminating this. I had posted a question/beef about this in Tek-Tips a few months ago and judging from from the replies, I got the impression that it...

This is good information to know. I hate to get negative on MS but I have to:

Why should a professional server administrator need to resort to "tricks"...

While I agree that in general cursors can adversely affect performance, I disagree with the conclusion that there is "always" a way to use a set operation rather than a...

We use a de-normalized data-mart--I may be using the term loosely but it's esssentially "a separate place for up-to-yesterday production data" where semi-trained users can put together queries on our...

I have been bitten by the IN/NOT IN null before...it's a tough one that had me scratching my head for an hour or so. That would make a good...

I'm not sure if this requires its own thread but--the only improvement I wanted to see is a simpler, more efficient Management Console which was foisted upon us in sql...

As a developer, the best practice here in my opinion, is to wrap all data update/inserts/deletes for those table into a stored procedure with the validation logic. All apps...

Yes...I'm glad I'm not the only one who thought this was a "How to pick-up chicks" article!

I use Ceridian HR/Payroll which uses this scheme. While I agree fully with the concept, there is a huge performance hit.

Have you ever seen the Execution plan when you...

Steve,

Thanks, that does make more sense. I'm thinking I'll just have a script to temporarily add the user to the dbDataWriter role, then remove it when my changes are...