SQL")"附近有语法错误应为IDcreatedatabasestudentonprimary(name='studentdata',filename='E:\SQL实验\student.mdf',size=10mb,maxsize=unlimited,filegrowth=10%,)

Question

SQL")"附近有语法错误应为ID
create database student
on primary(
name = 'student_data',
filename = 'E:\SQL实验\student.mdf',
size = 10mb,
maxsize = unlimited,
filegrowth = 10%,
)

Answer 1

create database student
on primary
(
name = 'student_data',
filename = 'E:\SQL实验\student.mdf',
size = 10mb,
maxsize = unlimited,
filegrowth = 10%--这的逗号去掉
)

首先必须保证你的路径是存在的

然后把我注释那地方的逗号去掉试试