use master
go
create database example
(
name=example,
filename = 'd:\data\examplemdf',
size = 10,
maxsize = 20,
filegrowth = 1
),
Filegroup filegroup1
(
name = datafile,
filename = 'd:\data\datafile1.ndf'
)
log on
(
name = example_log,
filename = 'd:\data\example_log.ldf'
)
go提示
Msg 102, Level 15, State 1, Line 3
'name' 附近有语法错误。但是我没有发现 语法有任何错误
go
create database example
(
name=example,
filename = 'd:\data\examplemdf',
size = 10,
maxsize = 20,
filegrowth = 1
),
Filegroup filegroup1
(
name = datafile,
filename = 'd:\data\datafile1.ndf'
)
log on
(
name = example_log,
filename = 'd:\data\example_log.ldf'
)
go提示
Msg 102, Level 15, State 1, Line 3
'name' 附近有语法错误。但是我没有发现 语法有任何错误
filename = 'd:\data\example.mdf',
go
create database example
(
name=example,
filename = 'd:\data\examplemdf',
size = 10,
maxsize = 20,
filegrowth = 1
), ==========
红色部分错了。。
实在不行,查联机丛书嘛。
name='example'
并且 filename 改成 ‘d:\data\example.mdf’
也还是不行
use master
go
create database example
ON PRIMARY(
name = 'example',
filename = 'd:\data\example.mdf',
size = 10,
maxsize = 20,
filegrowth = 1
),
Filegroup filegroup1
(
name = 'datafile',
filename = 'd:\data\datafile1.ndf'
)
log on
(
name = 'example_log',
filename = 'd:\data\example_log.ldf'
)
go
use master
go
create database example
ON PRIMARY(
name = 'example',
filename = 'd:\data\example.mdf',
size = 10,
maxsize = 20,
filegrowth = 1
),
Filegroup filegroup1
(
name = 'datafile',
filename = 'd:\data\datafile1.ndf'
)
log on
(
name = 'example_log',
filename = 'd:\data\example_log.ldf'
)
go
use master
go
create database example on primary
(
name =example,
filename = 'd:\data\example.mdf',
size = 10,
maxsize = 20,
filegrowth = 1
),
Filegroup filegroup1
(
name = datafile,
filename = 'd:\data\datafile1.ndf'
)
log on
(
name = example_log,
filename = 'd:\data\example_log.ldf'
)
go
use master
go
create database example
on --添加
primary --添加
(
name=example,
filename = 'd:\data\example.mdf',
size = 10MB,
maxsize = 20,
filegrowth = 1
),
Filegroup filegroup1
(
name = datafile,
filename = 'd:\data\datafile1.ndf'
)
log on
(
name = example_log,
filename = 'd:\data\example_log.ldf'
)
go