I've got to go with Kevin on this one... My soul dies a little every time I review a script that has a CREATE TABLE script that looks like this...

CREATE TABLE ImAnAss (
    ID INT IDENTITY PRIMARY KEY,
    SomeColumn VARCHAR,
    AnotherColumn DECIMAL DEFAULT (0),
    TheDate DATETIME DEFAULT (GETDATE())
    );