use sample create table dimissionpeople ( int id not null , nvarchar(10) name not null , nvarchar(12) deparment not null, varchar(12) zhubie not null, varchar(8) anoffice not null, datetime(16) indate not null, datetime(16) outdate not null,
varchar (10) dimission not null) 请问这是哪儿错了??
varchar (10) dimission not null) 请问这是哪儿错了??
)
(
id int not null
)
use sample
go
create table dimissionpeople ( id int not null , name nvarchar(10) not null , deparment nvarchar(12) not null, zhubie varchar(12) not null, anoffice varchar(8) not null, indate datetime not null, outdate datetime not null, dimission varchar (10) not null )
命令已成功完成。
create table dimissionpeople ( id int not null , [name] nvarchar(10) not null , deparment nvarchar(12) not null, zhubie varchar(12) not null, anoffice varchar(8) not null, indate datetime not null, -->datetime不能指定列宽 outdate datetime not null, -->datetime不能指定列宽 dimission varchar (10) not null ) --写反了
use sample create table dimissionpeople
(
id int not null ,
name nvarchar(10) not null ,
deparment nvarchar(12) not null,
zhubie varchar(12) not null,
anoffice varchar(8) not null,
indate datetime not null,
outdate datetime not null,
dimission varchar (10) not null
)
看来楼主是初学者啊,好好看看书哦