I agree.  The primary reasons I use GUIDs are for replication and/or for generating unique alphanumeric transaction ID's, etc.  It's just too bad that there is no built-in support for...

I've created some SP's similar to yours - where you are basically checking for the existence of a value in a column to avoid duplicates.  This could also be achieved...

Hey Adam,

What about base conversion or encryption UDT's?  It seems like they might be prime for something like that involving simple scalar data.  Just wondering...  Thanks.

I would argue that storing snapshots of a bill, separately from the actual bill data, is a poor design decision.  If a bill is to remain the same, then the...

That's really the best way to do it - assign NEWID() to a UNIQUEIDENTIFIER variable and insert it into a UNIQUEIDENTIFIER column; then return the value using an OUTPUT parameter.

I've...

I think it's a fair/decent question.  A good job candidate should be prepared to ask the only relevant question when presented with this question:  "What is the scope?"  That's the...

Note that some Windows 2003 systems might require modification to the ADD_XP.SQL installation script.  The following is a script change that might need to be made for some Windows 2003...

Hehe.  I had the little rubber raised key overlay for the TS-1000 you could set directly on top of the flat keyboard to simulate a real keyboard.

Then one day I went...

Thanks for the feedback Frank.  I hope you find it useful!

That's incredible.  He even had the nerve to put his picture up next to it.  If it's reported to MSN as a copyright violation, they might be obligated to pull...

Just ran into the first issue - you can't declare a TEXT local variable.  I'll keep looking into it and see what I can come up with, but TEXT type's...

Not sure, I didn't try it with TEXT datatype.  The only potential problem I can see is if SQL Server passes TEXT parameters differently from other parameters (or if it...

Hmm.  It's in the \WINDOWS\Microsoft.NET\Framework\v1.1.4322 directory on all my computers.  I believe it's installed with the .NET Framework.

UPDATE POSTED

I've found the issue, and I'll see if I can get the guys here to post an update to the code shortly.  Basically Blowfish deals with text in multiples...

I'll take a look at it and post something for you tonight.  Thanks!