alter table yourtable add default getdate() for yourcol
测试:create table b( seq_no int identity(1,1), b varchar(10), c datetime ) go alter table b add default getdate() for c with values go insert into b(b) values('a') insert into b(b) values('b') insert into b(b) values('d') insert into b(b) values('c') select * from bdrop table b
seq_no int identity(1,1),
b varchar(10),
c datetime
)
go
alter table b add default getdate() for c with values
go
insert into b(b) values('a')
insert into b(b) values('b')
insert into b(b) values('d')
insert into b(b) values('c')
select * from bdrop table b