能否设置字段的默认值为增加字段时的当前时间？

[lwd2k]

1

[Coolyu0916]

getdate()

[愉快的登山者]

alter table a1 with check
add default getdate() for edate

[psxfghost]

alter table tablename drop constraint constraintname

alter table tablename add constraint constraintname default(getdate()) for 字段

insert into tablename ....

alter table tablename drop constraint constraintname

可以去:
http://www.sqlteam.com/item.asp?ItemID=2232
^_^

[psxfghost]

CREATE TABLE AD_Form(
AD_Form_ID NUMERIC(10, 0) NOT NULL,
Created DATEtime NOT NULL default getdate(),
CreatedBy NUMeric(10, 0) NOT NULL,
Updated DATEtime NOT NULL default getdate(),
UpdatedBy NUMeric(10, 0) NOT NULL,
Name VARCHAR(60) NOT NULL,
Description VARCHAR(255),
CONSTRAINT AD_Form_Key PRIMARY KEY (AD_Form_ID)
)
转自:http://expert.csdn.net/Expert/topic/1367/1367620.xml?temp=.6390497

[yoki]

只要将默认值设为getdate()即可