SQL语言语法错误(第九行报语法错误，请问为什么）

来源：百度知道 编辑：UC知道 时间：2024/07/07 09:33:33
create database centermanagement
on primary
(name='cm_1',
filename='D:\James\Database\cm_1.mdf',
size=5,
maxsize=20,
filegrowth=1
)

(name='cm_2',

filename='D:\James\Database\cm_2.ndf',
size=5,
maxsize=20,
filegrowth=1
)
log on
(name='cm_log',
filename='D:\James\Database\cm_3.ldf',
size=5,
maxsize=20,
filegrowth=1
)

仔细看中间少了个逗号

create database centermanagement
on primary
(name='cm_1',
filename='D:\James\Database\cm_1.mdf',
size=5,
maxsize=20,
filegrowth=1
)
,
(name='cm_2',

filename='D:\James\Database\cm_2.ndf',
size=5,
maxsize=20,
filegrowth=1
)
log on
(name='cm_log',
filename='D:\James\Database\cm_3.ldf',
size=5,
maxsize=20,
filegrowth=1
)