Calvin,

nice and cute one!

May I add this to my site, so the users can decide for themselves which one to use?

What about starting up Profiler and see what's going on behind the scenes?

Steve,

time to wake up.

You see the difference

@frank, Rohini and Jeff: Phua, you would really go the extra mile and create a table with all possible date velues?

Yes!

You might want to read in BOL about it first as your question is very vague and unclear and come back with more specific questions after reading it.

Sorry, forgot to mention, that this question might be better asked in a C# community as it seems primarily related to the language rather than SQL Server.

See, if this helps:

http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1161.mspx

Not exactly, the NULL bitmap is always there, even if no column allows for NULL.

There are surely more than one way to skin that cat when you go down and touch system objects directly.

SELECT

 USER_NAME(so.uid) Owner

 , so.name [Table]

FROM

 sysobjects so

LEFT JOIN

 (

 SELECT...

IIRC, you might also want to search the script archive here. James Travis (aka Antares686) has posted such a script. It should help you.

No, it won't work this way. Stored Procedures can accept parameters, of course, but not with such a direct user interaction like a Inputbox. You might want to read the...

You're welcome!

Glad I could help.

Frank, love the pattern searching for this.  My only gripe is that your function is not set based. 

Yes, that's right, but the data doesn't really seems to be normalized....

Sorry, I'm not that much into VB anymore, but after reading your link, have you tried adVarLongBinary? But I think there are MS hosted newsgroups about VB and databases. Maybe...

It is actually not the best idea to name columns with reserved words. You should really change this.