消息 102,级别 15,状态 1,第 8 行'NAME' 附近有语法错误.
CREATEDATABASEStudentsONPRIMARY(NAME=students_data1,FILENAME='F:\Data\students_data1....
CREATE DATABASE Students
ON PRIMARY
( NAME = students_data1,
FILENAME = 'F:\Data\students_data1.mdf',
SIZE = 5,
MAXSIZE = UNLIMITED,
FILEGROWTH = 1)
( NAME = students_data2,
FILENAME = 'D:\Data\students_data2.ndf',
SIZE = 8,
MAXSIZE = 20,
FILEGROWTH = 2)
LOG ON
( NAME = students_log1,
FILENAME='E:\Log\students_log1.ldf',
SIZE = 2,
MAXSIZE = 6,
FILEGROWTH = 10%)
( NAME = students_log2,
FILENAME = 'D:\Log\students_log2.ldf',
SIZE = 3,
MAXSIZE = 8,
FILEGROWTH = 1) 展开
ON PRIMARY
( NAME = students_data1,
FILENAME = 'F:\Data\students_data1.mdf',
SIZE = 5,
MAXSIZE = UNLIMITED,
FILEGROWTH = 1)
( NAME = students_data2,
FILENAME = 'D:\Data\students_data2.ndf',
SIZE = 8,
MAXSIZE = 20,
FILEGROWTH = 2)
LOG ON
( NAME = students_log1,
FILENAME='E:\Log\students_log1.ldf',
SIZE = 2,
MAXSIZE = 6,
FILEGROWTH = 10%)
( NAME = students_log2,
FILENAME = 'D:\Log\students_log2.ldf',
SIZE = 3,
MAXSIZE = 8,
FILEGROWTH = 1) 展开
展开全部
--差个逗号
CREATE DATABASE Students
ON PRIMARY
( NAME = students_data1,
FILENAME = 'F:\Data\students_data1.mdf',
SIZE = 5,
MAXSIZE = UNLIMITED,
FILEGROWTH = 1),
( NAME = students_data2,
FILENAME = 'D:\Data\students_data2.ndf',
SIZE = 8,
MAXSIZE = 20,
FILEGROWTH = 2)
LOG ON
( NAME = students_log1,
FILENAME='E:\Log\students_log1.ldf',
SIZE = 2,
MAXSIZE = 6,
FILEGROWTH = 10%),
( NAME = students_log2,
FILENAME = 'D:\Log\students_log2.ldf',
SIZE = 3,
MAXSIZE = 8,
FILEGROWTH = 1)
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询