create table student
(sno char(9)primary key,
sname char(20)unique,
ssex char(2),
sage int,
sdept char(20));alter table student add s_entrance datetime;
为什么在最后加入列s_entrance 时数据类型用date时,得出结果出错为“找不到date数据类型”啊?
(sno char(9)primary key,
sname char(20)unique,
ssex char(2),
sage int,
sdept char(20));alter table student add s_entrance datetime;
为什么在最后加入列s_entrance 时数据类型用date时,得出结果出错为“找不到date数据类型”啊?
create table student
(sno char(9)primary key,
sname char(20)unique,
ssex char(2),
sage int,
sdept char(20));
go--加个go看看
alter table student add s_entrance datetime
create table student
(sno char(9)primary key,
sname char(20)unique,
ssex char(2),
sage int,
sdept char(20));alter table student add s_entrance date;