消息 102,级别 15,状态 1,第 8 行'NAME' 附近有语法错误.

Question

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)

Answer 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)