Looks like it will need to be one table at a time then eh? It looks like there is actually 600 or so tables 🙁

Hi Steve,

Thanks for the link. Where is the import wizard that you mention? I do not need to deal with updates, just inserts, so that sounds like a...

peter-757102 (2/10/2010)

CraigIW (2/10/2010)

No, as the "top 1" is only done after the "select...

No, as the "top 1" is only done after the "select 1 from".

Quite liked that one, though as surprised as you at the efficiency. Will give it a bash sometime.

Or you could just store it as a block of XML?

Nope, doesn't cut it for me yet.  Nice idea, but I still don't see a point in it, and have...

Are you really sure about this?  And is it only for SQL Server?  Every hot fix I have ever installed for another product explicitly states 'this hotfix is deisgned to...

I agree with jc, the kb is about sql 2000 and I thought you were saying 2005 has the password log bug.

On Microsoft testing in general, it can be good...

Good writeup!

My theory is that anything too hard-hitting will grow boring over time, so most of them need to be able to just flow over you, with a smattering of blood-stirrers.

Got...

Nice little technique. 

Reminds me of when I realised the power of of using

(col = @arg OR Len(@arg) = 0)

for only using passed values in joins...