Question

'(' 附近有语法错误。 数据库SQL

创建数据库时候提示这个错误,郁闷,在实验室都没这个问题的...

CREATE DATABASE STUDENT1
ON PRIMARY
( NAME=STUDENT()_DAT,
FILENAME='D:\sjk\STUDENT()_DAT.MDF',
SIZE=10MB,
MAXSIZE=100MB,
FILEGROWTH=10%)
LOG ON
( NAME=STUDENT()_LOG,
FILENAME='D:\sjk\STUDENT()_LOG.LDF',
SIZE=5MB,
MAXSIZE=UNLIMITED,
FILEGROWTH=10%)
提示是第3行

Answer 1

//数据库名不能加括号，把括号去掉。

CREATE DATABASE STUDENT1
ON PRIMARY
(
NAME=STUDENT_DAT,
FILENAME='D:\sjk\STUDENT_DAT.MDF',
SIZE=10MB,
MAXSIZE=100MB,
FILEGROWTH=10%
)
LOG ON
( NAME=STUDENT_LOG,
FILENAME='D:\sjk\STUDENT_LOG.LDF',
SIZE=5MB,
MAXSIZE=UNLIMITED,
FILEGROWTH=10%
)
GO