【SQL开源代码栏目提醒】:网学会员在SQL开源代码频道为大家收集整理了CH06.sql提供大家参考,希望对大家有所帮助!
-- P6-13a
CREATE DATABASE 产品资料库
ON
( NAME = 产品资料库,
FILENAME = 'C:\SQLTEST\产品资料库.MDF' )
-- P6-13b
CREATE DATABASE 机密产品资料库
ON
( NAME = 机密产品资料_1,
FILENAME = 'C:\SQLTEST\机密产品资料_1.MDF',
SIZE = 10MB,
MAXSIZE = 50MB,
FILEGROWTH = 5 )
-- P6-13c
CREATE DATABASE 销售资料库
ON PRIMARY
( NAME = 销售资料档_1,
FILENAME = 'C:\SQLTEST\销售资料档_1.MDF',
SIZE = 5, MAXSIZE = 10, FILEGROWTH = 15% ) ,
( NAME = 销售资料档_2,
FILENAME = 'C:\SQLTEST\销售资料档_2.NDF',
SIZE = 5, MAXSIZE = 10, FILEGROWTH = 15% ) ,
FILEGROUP 销售资料库档案群_1
( NAME = 销售资料库档案群_1_档案_1,
FILENAME = 'C:\SQLTEST\销售资料库档案群_1_档案_1.NDF',
SIZE = 5, MAXSIZE = 10, FILEGROWTH = 5 ) ,
( NAME = 销售资料库档案群_1_档案_2,
FILENAME = 'C:\SQLTEST\销售资料库档案群_1_档案_2.NDF',
SIZE = 5, MAXSIZE = 10, FILEGROWTH = 5 ) ,
FILEGROUP 销售资料库档案群_2
( NAME = 销售资料库档案群_2_档案_1,
FILENAME = 'C:\SQLTEST\销售资料库档案群_2_档案_1.NDF',
SIZE = 5, MAXSIZE = 10, FILEGROWTH = 5 ) ,
( NAME = 销售资料库档案群_2_档案_2,
FILENAME = 'C:\SQLTEST\销售资料库档案群_2_档案_2.NDF',
SIZE = 5, MAXSIZE = 10, FILEGROWTH = 5 )
-- P6-15
SELECT *
FROM ::fn_helpcollations()
-- P6-18
EXEC sp_detach_db '销售资料库'
-- P6-20a
CREATE DATABASE 销售资料库
ON PRIMARY
(FILENAME = 'C:\SQLTEST\销售资料档_1.MDF')
FOR ATTACH
-- P6-20b
EXEC sp_attach_db 产品资料库,
'C:\SQLTEST\产品资料库.MDF'
-- P6-30a
ALTER DATABASE 藏经阁
MODIFY NAME = NEWAAA
-- P6-30b
EXEC sp_renamedb 'NEWAAA', '藏经阁'
-- P6-31
ALTER DATABASE 销售资料库
MODIFY FILEGROUP 销售资料库档案群_2 DEFAULT
-- P6-33
ALTER DATABASE 销售资料库
ADD LOG FILE
( NAME = 销售日志_2,
FILENAME = 'C:\SQLTEST\销售日志_2.LDF',
MAXSIZE = 100 MB )
-- P6-35a
DROP DATABASE 藏经阁, 订单资料库
-- P6-35b
EXEC sp_helpdb