Question

sql server 创建数据库语句不知道哪错了 就说on附近有语法错误呢

create database
on primary
(name = 'teaching',
filename='G:\sqlprogram\teaching.mdf',
size=4MB,
maxsize=30MB,
filegrowth=1MB,)
log on
(name='teaching_log',
filename='G:\sqlprogram\teaching_log.ldf',
size=2MB,
maxsize=10MB,
filegrowth=10%)
collate Chinese_PRC_CI_AS
GO

Answer 1

没指定数据库名字、
create database test
on primary
(...)