If it truly is a "DateTime" column, it just doesn't matter what format you store it in so long as it is one recognized by SQL.  It will have the...

Not trying to be difficult here... hex doesn't normally work quite the way you described so could you post an example of the hex number and what the expected outcome...

Can't be done.  The purpose of having a username and password is to keep people out unless they know the username and password.  Sorry...

I second the nomination on...

http://www.w3schools.com/sql/default.asp

scking,

I'm curious... what is your objection to using ISNULL or it's big brother, COALESCE?  Yes, CASE works but it's probably not a fast as ISNULL...  your last CASE example could...

Miller Time,

Don't define the new column as a TimeStamp datatype... the TimeStamp data type in MS-SQL Server is actually a binary number used for row versioning and has nothing to...

Do you want the time included in the default, or not?  All of the posts, so far, include time.

That's a pretty good two cents... lot's of folks forget that there IS a difference between 90 days and 3 months.

JN, here's the code without the time stripping part... that's...

Don't forget that just subtracting 90 days using either method will not take you to midnight of the given day... the current time element will be included unless you do...

This'll work if you have a DBA that doesn't understand the merits of a date table and it's short enough to use in inline code if the...

Hopefully, SP4 will fix some of the memory leaks.  It came out this last Friday.

The problem in our shop used to be that no-one did a code review of other's...

I second Carl's suggestion about turning AutoShrink off... AutoShrink causes several problems not the least of which can be severe disk fragmentation and long wait times when it does need...

I don't believe I'd use a trigger for this because if the Oracle DB or the connection to it is down, then your SQL Server...

I don't believe I'd use a trigger for this because if the Oracle DB or the connection to it is down, then your SQL Server processes will start kicking off...

I believe that it's called an "M-Space" and occupies the same width as the letter 'M", hence the name.  Since it's not a regular space character (ASCII 32), you may...