谁给看看它说在第二行关键字 'on' 附近有语法错误.我怎么改啊create database libraryon (name=librarydata,filename ='d:\sql2\librarydata.mdf')log on (name='librarylog',filename='d:\sql2\librarylog.ldf')

谁给看看它说在第二行关键字 'on' 附近有语法错误.我怎么改啊create database libraryon (name=librarydata,filename ='d:\sql2\librarydata.mdf')log on (name='librarylog',filename='d:\sql2\librarylog.ldf')
谁给看看它说在第二行关键字 'on' 附近有语法错误.我怎么改啊
create database library
on
(name=librarydata,
filename ='d:\sql2\librarydata.mdf'
)
log on
(name='librarylog',
filename='d:\sql2\librarylog.ldf'
)

谁给看看它说在第二行关键字 'on' 附近有语法错误.我怎么改啊create database libraryon (name=librarydata,filename ='d:\sql2\librarydata.mdf')log on (name='librarylog',filename='d:\sql2\librarylog.ldf')
name=librarydata少单引号,应该是
create database library
on
(name=‘librarydata’,
filename ='d:\sql2\librarydata.mdf'
)
log on
(name='librarylog',
filename='d:\sql2\librarylog.ldf'
)
试下吧