alter database test3 add file test3_dat5 TO FILEGROUP test3Group2 ( name='test3_dat5', filename='f:\数据库\test3_dat5.ndf', size=10MB, maxsize=50MB, filegrowth=5MB )
go 还不对
alter database test3 add file ( name='test3_dat5', filename='f:\数据库\test3_dat5.ndf', size=10MB, maxsize=50MB, filegrowth=5MB ) TO FILEGROUP test3Group2 go
alter database test3 add file test3_dat5 ( name='test3_dat5', filename='f:\数据库\test3_dat5.ndf', size=10MB, maxsize=50MB, filegrowth=5MB ) TO FILEGROUP test3Group2 go try it ;)
alter database test3 add file ( name='test3_dat5', filename='f:\数据库\test3_dat5.ndf', size=10MB, maxsize=50MB, filegrowth=5MB ) TO FILEGROUP test3Group2 go 这个有错吗?
alter database test3 add file test3_dat5 ( name='test3_dat5', filename='f:\数据库\test3_dat5.ndf', size=10MB, maxsize=50MB, filegrowth=5MB ) TO FILEGROUP test3Group2 go 第 3 行: '(' 附近有语法错误。
你再看看两个一样嘛!!粗心啊~~~!alter database test3 add file ( name='test3_dat5', filename='f:\数据库\test3_dat5.ndf', size=10MB, maxsize=50MB, filegrowth=5MB ) TO FILEGROUP test3Group2 go 这个有错吗? --------------- alter database test3 add file test3_dat5 ( name='test3_dat5', filename='f:\数据库\test3_dat5.ndf', size=10MB, maxsize=50MB, filegrowth=5MB ) TO FILEGROUP test3Group2 go 第 3 行: '(' 附近有语法错误。
ALTER DATABASE test1
add file test1_dat to filegroup test1Group1
还是提示to附近错
ADD FILE
(
NAME = Test1dat2,
FILENAME = 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\t1dat2.ndf',
SIZE = 5MB,
MAXSIZE = 100MB,
FILEGROWTH = 5MB
)
add file test3_dat5 TO FILEGROUP test3Group2
( name='test3_dat5',
filename='f:\数据库\test3_dat5.ndf',
size=10MB,
maxsize=50MB,
filegrowth=5MB
)
go
还不对
add file
( name='test3_dat5',
filename='f:\数据库\test3_dat5.ndf',
size=10MB,
maxsize=50MB,
filegrowth=5MB
)
TO FILEGROUP test3Group2
go
add file test3_dat5
( name='test3_dat5',
filename='f:\数据库\test3_dat5.ndf',
size=10MB,
maxsize=50MB,
filegrowth=5MB
)
TO FILEGROUP test3Group2
go
try it ;)
add file
( name='test3_dat5',
filename='f:\数据库\test3_dat5.ndf',
size=10MB,
maxsize=50MB,
filegrowth=5MB
)
TO FILEGROUP test3Group2
go
这个有错吗?
add file test3_dat5
( name='test3_dat5',
filename='f:\数据库\test3_dat5.ndf',
size=10MB,
maxsize=50MB,
filegrowth=5MB
)
TO FILEGROUP test3Group2
go
第 3 行: '(' 附近有语法错误。
add file
( name='test3_dat5',
filename='f:\数据库\test3_dat5.ndf',
size=10MB,
maxsize=50MB,
filegrowth=5MB
)
TO FILEGROUP test3Group2
go
这个有错吗?
---------------
alter database test3
add file test3_dat5
( name='test3_dat5',
filename='f:\数据库\test3_dat5.ndf',
size=10MB,
maxsize=50MB,
filegrowth=5MB
)
TO FILEGROUP test3Group2
go
第 3 行: '(' 附近有语法错误。