sql查错sql查错

来源：百度知道 编辑：UC知道 时间：2024/06/29 19:05:32
create database Sales
on
primary SalDat01
(name=SalDat01,
filename='c:\DB\SalDat01.mdf')
filegroup SalDat02
(name=SalDat11,
filename='d:\DB\SalDat11.ndf')
(name=SalDat12,
filename='d:\DB\SalDat12.ndf')
(name=SalDat13,
filename='d:\DB\SalDat13.ndf')

赐教 谢谢

primary 后面--SalDat01去掉就行了

create database Sales
on primary --SalDat01去掉就行了
(
name=SalDat01,
filename='c:\DB\SalDat01.mdf')
,
filegroup SalDat02
(name=SalDat11,
filename='d:\DB\SalDat11.ndf'),
(name=SalDat12,
filename='d:\DB\SalDat12.ndf'),
(name=SalDat13,
filename='d:\DB\SalDat13.ndf')

括号后面要加逗号的','
create database Sales
on
primary SalDat01
(name=SalDat01,
filename='c:\DB\SalDat01.mdf'),
filegroup SalDat02
(name=SalDat11,
filename='d:\DB\SalDat11.ndf'),
(name=SalDat12,
filename='d:\DB\SalDat12.ndf'),
(name=SalDat13,
filename='d:\DB\SalDat13.ndf')

create database Sales
on
primary
(name=SalDat01,
filename='c:\DB\SalDat01.mdf'),
filegroup SalDat02
(name=SalDat11,