The CURRENT_TIMESTAMP function returns this value.
4>
5> CREATE TABLE T (
6> int1 int,
7> bit1 bit NOT NULL DEFAULT 0,
8> rvr1 timestamp,
9> usr1 nvarchar(128) DEFAULT USER,
10> createtime datetime DEFAULT CURRENT_TIMESTAMP
11> )
12> GO
1>
2> drop table t;
3>