CREATE DATABASE student
ON
(NAME=student,
FILENAME='E: \sql_data \student.mdf',
SIZE=10MB,
MAXSIZE=50MB,
FILEGROWTH=10%),
LOG ON
(NAME=student_log,
FILENAME='E: \sql_data \student_log.ldf',
SIZE=2MB,
MAXSIZE=5MB,
FILEGROWTH=1MB),CREATE TABLE student
(sNO varchar (10) PRIMARY KEY,
sName varchar (20) NOT NULL,
mNO char (6) NOT NULL,
sSex char (4),
sNative varchar(20),
sBirth smalldatetime,--出生日期
sHeigh int,
sWeight int,
sEntime smalldatetime
);
结果
消息 102,级别 15,状态 1,第 8 行
'LOG' 附近有语法错误。
ON
(NAME=student,
FILENAME='E: \sql_data \student.mdf',
SIZE=10MB,
MAXSIZE=50MB,
FILEGROWTH=10%),
LOG ON
(NAME=student_log,
FILENAME='E: \sql_data \student_log.ldf',
SIZE=2MB,
MAXSIZE=5MB,
FILEGROWTH=1MB),CREATE TABLE student
(sNO varchar (10) PRIMARY KEY,
sName varchar (20) NOT NULL,
mNO char (6) NOT NULL,
sSex char (4),
sNative varchar(20),
sBirth smalldatetime,--出生日期
sHeigh int,
sWeight int,
sEntime smalldatetime
);
结果
消息 102,级别 15,状态 1,第 8 行
'LOG' 附近有语法错误。
CREATE DATABASE student
ON
(NAME=student,
FILENAME='E:\sql_data\student.mdf',
SIZE=10MB,
MAXSIZE=50MB,
FILEGROWTH=10%)
LOG ON
(NAME=student_log,
FILENAME='E:\sql_data\student_log.ldf',
SIZE=2MB,
MAXSIZE=5MB,
FILEGROWTH=1MB)
GO
CREATE TABLE student
(sNO varchar (10) PRIMARY KEY,
sName varchar (20) NOT NULL,
mNO char (6) NOT NULL,
sSex char (4),
sNative varchar(20),
sBirth smalldatetime,--出生日期
sHeigh int,
sWeight int,
sEntime smalldatetime
);
ON
(NAME=student,
FILENAME='E:\sql_data\student.mdf',
SIZE=10MB,
MAXSIZE=50MB,
FILEGROWTH=10%)
LOG ON
(NAME=student_log,
FILENAME='E:\sql_data\student_log.ldf',
SIZE=2MB,
MAXSIZE=5MB,
FILEGROWTH=1MB)
GO
CREATE TABLE student
(sNO varchar (10) PRIMARY KEY,
sName varchar (20) NOT NULL,
mNO char (6) NOT NULL,
sSex char (4),
sNative varchar(20),
sBirth smalldatetime,--出生日期
sHeigh int,
sWeight int,
sEntime smalldatetime
);建议楼主认真学习。低级错误就不要拿出来