Mardy,

The smalldatetime and datetime datatypes are basically decimal datatype with a reference from a beginning period of time.  Each whole number equals 1 day.  That's why you can do "select...

Paul,

I've been writing T-SQL for about a 2yrs now and I've never seen such a function like that.  If you find one let me know because I make full use...

cbarus,

I agree with your first thought whole heartedly.  Here's some more ammo for your battle.

If you create a transaction in T-SQL for something that lasts a long period of time (ie like...

Well, I just found out that it can't be done...atleast not with SQL2K.

Here's an excerpt from BOL.

DEFAULT definitions

User-defined functions can be invoked as the constant_expression of DEFAULT definitions...