I find that the RegEx coach is a useful tool for checking RegEx.

Also try http://www.regexlib.com/

The following evaluates UK dates and takes account of leap years etc.

^(?

To use an analogy the CLR is rather like electric power tools.

In the hands of a competent person they are a God send allowing jobs that would otherwise be difficult...

In the UK 85% of the price of petrol is tax and we are at the £4 gallon (a US gallon is 5/8 of a UK one).

The UK is incredibly...

Chris,

If you have a bog standard SQL2000 function, for the sake of argument it multiplies one argument by another and you write a query that applies that function to records...

Coal's to Newcastle! Well if you've ever tried Newcastle Brown you would prefer to drink their coal. Apparently it is known as a bottle of dog because they...

Mike, studies trying to correlate factors such as low pay, bad environment etc with turnover tend to look at employees as units to be correlated rather than human beings.

How...

I don't need to. He is a noted trombone player and you can visit his web site for yourself!

I agree with the assessment on the breadth of his knowledge...

If ever you need a trombone player with a shark fetish Frank is your man!

I don't know about a specific bolt-on for SQL Server but our translation department tell me that there are automated translation dictionaries that do the bulk of the work.

The bulk...

I've seen an ORACLE database slaughtered by a web content management system in testing, but in real life it coped just fine.

One issue I have seen with testing is coming...

You say that the locking issue only applies at the default isolation level of READ COMMITTED

Surely this knocks the ORACLE guys argument for six because although it is the default...

I went to a SQL2005 tech-ed briefing and was told that ultimately SQL2000 was limited however no expense has been spared on SQL2005 to ensure that it does scale.

With SQL2000...

This question is a lobbed hand grenade. I hope the SQLServerCentral.com servers are up to the flaming.

Replace any single quote instances with two single quotes in your variables.

I should also use a stored procedure and use what ever the .NET equivalent of a Command object is...

SP4