【创建数据库的sql语句】(写出每个题目对应的T-SQL语句)1、在“d:\sqlserver”文件夹下...
答案:2 悬赏:0 手机版
解决时间 2021-02-14 10:29
- 提问者网友：謫仙
- 2021-02-13 16:12
【创建数据库的sql语句】(写出每个题目对应的T-SQL语句)1、在“d:\sqlserver”文件夹下...
最佳答案
- 五星知识达人网友：鸠书
- 2021-02-13 16:24
【答案】 1、第一题
create database ReadBook
on
(name=ReadBook_data,
filename='d:\sqlserver\readbook.mdf',
size=2,
filegrowth=1,
maxsize = 5
)
log on
(name=ReadBook_log,
filename='d:\sqlserver\readbook.ldf',
size=1,
filegrowth=1,
maxsize = 5
)
2、第二题
alter database ReadBook
add filegroup bookgroup
go
alter database ReadBook
add file
( name='book2_dat',
filename='d:\sqlserver\book2_dat',
size=5,
maxsize=50,
filegrowth=5)
3、第三题
alter database ReadBook
remove file book2_dat
4、第四题
alter database ReadBook
remove filegroup bookgroup
create database ReadBook
on
(name=ReadBook_data,
filename='d:\sqlserver\readbook.mdf',
size=2,
filegrowth=1,
maxsize = 5
)
log on
(name=ReadBook_log,
filename='d:\sqlserver\readbook.ldf',
size=1,
filegrowth=1,
maxsize = 5
)
2、第二题
alter database ReadBook
add filegroup bookgroup
go
alter database ReadBook
add file
( name='book2_dat',
filename='d:\sqlserver\book2_dat',
size=5,
maxsize=50,
filegrowth=5)
3、第三题
alter database ReadBook
remove file book2_dat
4、第四题
alter database ReadBook
remove filegroup bookgroup
全部回答
- 1楼网友：大漠
- 2021-02-13 16:48
哦，回答的不错
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
大家都在看
推荐资讯