实验步骤和调试过程(实验步骤、测试数据设计、测试结果分析)
-
创建数据库
用命令 CREATE DATABASE 完成下列操作:
注:XXX为学号最后三位1.创建数据库dbXXXA,不指定任何文件,然后用SP_HELPDB查看结果;
CREATE DATABASE DB061A
GO
EXEC SP_HELPDB DB061A
2.创建数据库dbXXXB,仅指定一个数据文件,参数自定,然后查看结果;
CREATE DATABASE [db061B]
CONTAINMENT = NONE
ON PRIMARY
( NAME = N’db061B’, FILENAME = N’C:\Program Files\Microsoft SQL
Server\MSSQL15.SQLEXPRESS\MSSQL\DATA\db061B.mdf’ , SIZE = 8192KB , MAXSIZE =
UNLIMITED, FILEGROWTH = 65536KB ),
( NAME = N’db061B_1’, FILENAME = N’C:\Program Files\Microsoft SQL
Server\MS