当前位置: 代码迷 >> Sql Server >> 新手求帮助解决方法
  详细解决方案

新手求帮助解决方法

热度:169   发布时间:2016-04-27 14:04:30.0
新手求帮助
sql2005创建数据库遇到问题。。
SQL code
create database db1on primary(name = db1_p01, filename = 'F:\\db\db1_p01.mdf',size = 5mb, maxsize = unlimited, filegrowth = 1mb,)filegroup db1_g01(name = db1_g01_01,filename = 'F:\\db\db1_g01_01.ndf',size = 10mb,maxsize = 100mb,filegrowth = 50%)Msg 102, Level 15, State 1, Line 9')' 附近有语法错误。哪错了啊。


------解决方案--------------------
SQL code
create database db1on primary(name = db1_p01, filename = 'F:\\db\db1_p01.mdf',size = 5mb, maxsize = unlimited, filegrowth = 1mb--这里多一逗号)
------解决方案--------------------
SQL code
create database db1on primary(name = db1_p01, filename = 'F:\db\db1_p01.mdf',size = 5mb, maxsize = unlimited, filegrowth = 1mb),filegroup db1_g01(name = db1_g01_01,filename = 'F:\db\db1_g01_01.ndf',size = 10mb,maxsize = 100mb,filegrowth = 50%)
  相关解决方案