帮忙看一段SQL语句

来源：百度知道 编辑：UC知道 时间：2024/06/05 08:33:18
我用SQL Server2000的查询分析器执行下面这段代码，可是总显示出错，大家帮忙看看有什么地方不对？谢谢啊！
create database ncdxxww;

create table news
(
newsid int primary key auto_increment,
title varchar(255),
content text,
newsfrom varchar(60),
viewers int,
conments int,
type int,
newsdate date
);

create table conment
(
conmentid int primary key auto_increment,
newsid int references news.newsid,
conment text,
fromip varchar(15),
conmentdate date

);

create table admin
(
name varchar(20),
password varchar(20)
);

老弟你弄的sql是MYSQL的语句，当然会报错了，给你改写了分MSSQL的语句就不报错了，直接copy，f5执行。

create database ncdxxww
go
use ncdxxww
go

create table news
(
newsid int identity(1,1) primary key,
title varchar(255),
content text,
newsfrom varchar(60),
viewers int,
conments int,
type int,
newsdate datetime
)
go

create table conment
(
conmentid int identity(1,1) primary key,
newsid int foreign key references news(newsid),
conment text,
fromip varchar(15),
conmentdate datetime

)
go

create table admin
(
name varchar(20),
password varchar(20)
)