或alter table #t add constraint U_default_#T default(1) for ID--列
CREATE TABLE #tb ( id intDEFAULT 0 )
create table #t (id int default(1),name varchar(10), constraint 约束名 default('张三') for name )
create table #t( id int identity(1,1), name varchar(8) not null default('无名氏'), crtdate datetime not null default(getdate()));
create table #t(name varchar(8) not null , crtdate datetime not null ) alter table #t add constraint U_default1_#T default('li') for name alter table #t add constraint U_default2_#T default(getdate()) for crtdateinsert #t select '','2008.12.01' select * from #t drop table #t 不能为具有 IDENTITY 特性的列创建默认值
create default def_chirstmas as '11-02-1987' --设置的默认值是 11-02-1987
id int
DEFAULT 1 -- 默认值
);
(
id intDEFAULT 0
)
create table #t
(id int default(1),name varchar(10),
constraint 约束名 default('张三') for name
)
create table #t(
id int identity(1,1),
name varchar(8) not null default('无名氏'),
crtdate datetime not null default(getdate()));
crtdate datetime not null )
alter table #t add constraint U_default1_#T default('li') for name
alter table #t add constraint U_default2_#T default(getdate()) for crtdateinsert #t
select '','2008.12.01'
select * from #t
drop table #t
不能为具有 IDENTITY 特性的列创建默认值
create default def_chirstmas
as '11-02-1987' --设置的默认值是 11-02-1987
CREATE TABLE 表名(
字段名 类型 DEFAULT 默认值
);