create database school on primary ( name = data1,filename =
来源:学生作业帮 编辑:神马作文网作业帮 分类:综合作业 时间:2024/11/06 09:46:48
create database school on primary ( name = data1,filename = 'D:\Sqldata\datagroup\data1.mdf',size
create database school
on
primary
(
name = data1,
filename = 'D:\Sqldata\datagroup\data1.mdf',
size= 10,
maxsize=100,
filegrowth = 5),
(
name=data2,
filename='D:\Sqldata\datagroup\data2.ndf',
size=10,
maxsize=100,
filegrowth=5),
filegroup datagroup
(name=data11,
filename='D:\Sqldata\datagroup\data11.ndf',
size=10,
maxsize=100,
filegroup=5),
(name=data21,
filename='D:\Sqldata\datagroup\data21.ndf',
size=10,
maxsize=100,
filegroup=5),
log on
(
name = schoollog,
filename ='D:\Sqldata\datagroup\schoollog.ldf',
size=10mb,
maxsize =unlimited,
filegrowth =10%
)
加上单位后 服务器:消息 155,级别 15,状态 1,行 21
'filegroup' 不是可以识别的 CREATE/ALTER DATABASE 选项.
create database school
on
primary
(
name = data1,
filename = 'D:\Sqldata\datagroup\data1.mdf',
size= 10,
maxsize=100,
filegrowth = 5),
(
name=data2,
filename='D:\Sqldata\datagroup\data2.ndf',
size=10,
maxsize=100,
filegrowth=5),
filegroup datagroup
(name=data11,
filename='D:\Sqldata\datagroup\data11.ndf',
size=10,
maxsize=100,
filegroup=5),
(name=data21,
filename='D:\Sqldata\datagroup\data21.ndf',
size=10,
maxsize=100,
filegroup=5),
log on
(
name = schoollog,
filename ='D:\Sqldata\datagroup\schoollog.ldf',
size=10mb,
maxsize =unlimited,
filegrowth =10%
)
加上单位后 服务器:消息 155,级别 15,状态 1,行 21
'filegroup' 不是可以识别的 CREATE/ALTER DATABASE 选项.
size= 10,
maxsize=100,
filegrowth = 5),
等没有单位,应该会影响执行的.
D:\Sqldata\datagroup
目录是否存在也会影响执行的.
maxsize=100,
filegrowth = 5),
等没有单位,应该会影响执行的.
D:\Sqldata\datagroup
目录是否存在也会影响执行的.
mysql授权问题.Create database with same name and grant all privi
create table table_name (.) on primary 这儿的 on primary 是为了说明什
数据库中create table biao(id int(8) primary key,name varchar(10)
matlab程序:data2=[0,data1(1:end-1)]; (1:
primary school
=INDEX(Database!C4:C64,SMALL(IF(Database!F3:F64=Sheet1!B20,R
英语翻译1.My name is Jia Ming.I am a primary school pupil.I stud
I was on the school football team at primary school.的一般疑问句和否
my primary school
primary school作文
goodbye primary school 作文
primary school 中文翻译