create table ta
(
id int identity(1,1),
name varchar(10),
Now_time datetime default getdate()
)
insert into ta (name)
select 'a'
--你执行这个看看?
select * from ta
--结果是:
id name Now_time
----------- ---------- ------------------------------------------------------
1 a 2006-12-04 13:08:58.957