在SQL server 2005中 通过查询编辑器新建数据库,老提示第二行出错 但我看不出来哪错了 麻烦各位帮忙看看

2025-02-26 15:48:17
推荐回答(3个)
回答1:

修改后的代码已经在查询分析器中通过,并且已经成功建库。
create database mytest
on /*-------------------错误在这,少了一个on。*/
(name = test_dat,
filename = 'd:\testdat.mdf',
size = 10,
maxsize = 40,
filegrowth = 5
)

LOG ON
(NAME=test_log,
filename ='d:\testlog.ldf',
size = 50MB,
maxsize = 20MB,
filegrowth = 5MB
);
GO

回答2:

create database mytest
on
。。。

回答3:

少了一个 on ,应为create database mytest on

语法
CREATE DATABASE database_name
[ ON
[ < filespec > [
,...n ] ]
[ , < filegroup > [ ,...n
] ]
]
[ LOG ON { < filespec > [ ,...n ] } ]
[ COLLATE collation_name ]
[ FOR LOAD | FOR ATTACH ]
< filespec > ::=
[ PRIMARY ]
( [ NAME =logical_file_name ,
]
FILENAME ='os_file_name'
[ ,
SIZE =size ]
[ , MAXSIZE = { max_size
| UNLIMITED } ]
[ , FILEGROWTH =growth_increment ]
) [ ,...n ]
< filegroup > ::=
FILEGROUP filegroup_name < filespec > [ ,...n ]

范例:
USE master
GO
CREATE DATABASE Sales
ON
( NAME = Sales_dat,
FILENAME = 'c:\program files\microsoft sql server\mssql\data\saledat.mdf',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 )
LOG ON
( NAME = 'Sales_log',
FILENAME = 'c:\program files\microsoft sql server\mssql\data\salelog.ldf',
SIZE = 5MB,
MAXSIZE = 25MB,
FILEGROWTH = 5MB )
GO