sql创建数据库问题
来源:百度知道 编辑:UC知道 时间:2024/05/28 18:34:02
CREATE DATABASE teacher
ON
PRIMARY(NAME=teacher_data,
FILENAME='c:\program files\microsoft sql server\mssql\data\teacher_data.crm',
SIZE=100MB,
MAXSIZE=200,
FILEGROWTH=20)
LOG ON
(NAME=cmmeme_log,
FILENAME='c:\program files\microsoft sql server\mssql\data\teacher_log.ldf',
SIZE=100MB,
MAXSIZE=200,
FILEGROWTH=20),
GO
服务器: 消息 170,级别 15,状态 1,行 13
第 13 行: ',' 附近有语法错误。
请问各位问题出在哪里??
ON
PRIMARY(NAME=teacher_data,
FILENAME='c:\program files\microsoft sql server\mssql\data\teacher_data.crm',
SIZE=100MB,
MAXSIZE=200,
FILEGROWTH=20)
LOG ON
(NAME=cmmeme_log,
FILENAME='c:\program files\microsoft sql server\mssql\data\teacher_log.ldf',
SIZE=100MB,
MAXSIZE=200,
FILEGROWTH=20),
GO
服务器: 消息 170,级别 15,状态 1,行 13
第 13 行: ',' 附近有语法错误。
请问各位问题出在哪里??
FILEGROWTH=20),后面这个逗号可能是多余的
把这行FILEGROWTH=20),
最后的,删了
CREATE DATABASE teacher
ON
PRIMARY(NAME=teacher_data,
FILENAME='c:\program files\microsoft sql server\mssql\data\teacher_data.crm',
SIZE=100MB,
MAXSIZE=200,
FILEGROWTH=20)
LOG ON
(NAME=cmmeme_log,
FILENAME='c:\program files\microsoft sql server\mssql\data\teacher_log.ldf',
SIZE=100MB,
MAXSIZE=200,
FILEGROWTH=20)
GO
直接粘上
学学