首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > SQL Server >

新手求帮助解决方法

2012-03-16 
新手求帮助sql2005创建数据库遇到问题。。SQL codecreate database db1on primary(name db1_p01, filename

新手求帮助
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%) 

热点排行