提示[Microsoft][ODBC SQL Server Driver]语法错误或访问冲突，什么原因？

[Amour81]

在SQL查询分析器中运行下列语句：
use AA
go

create TABLE test1
{
job id smallint
IDENTITY(1,1)
constraint PK_ID PRIMARY KEY CLUSTERED,
job_desc varchar(50) NOT NULL
DEFUALT 'new Position',
}
go


提示[Microsoft][ODBC SQL Server Driver]语法错误或访问冲突

请问各位是什么原因？怎么解决？

[WangZWang]

-- 正确的写法
use AA
go
Create TABLE test1
(
jobid Int IDENTITY(1,1) not NULL
constraint PK_ID PRIMARY KEY CLUSTERED,
job_desc varchar(50) default 'new Position' NOT NULL
)
go

[gaoxiaospring]

create TABLE test1
(
[job id] smallint
IDENTITY(1,1)
constraint PK_ID PRIMARY KEY CLUSTERED,
job_desc varchar(50) NOT NULL
DEFAULT 'new Position'
)
go

{}-> ()
job id-> [job id]
DEFUALT-> DEFAULT

[skyboy0720]

create TABLE test1
(
job_id smallint IDENTITY(1,1) constraint PK_ID PRIMARY KEY CLUSTERED,
job_desc varchar(50) DEFAULT ('new Position') NOT NULL ,
)
go