实验2：使用向导创建并管理数据库_20140320173228.doc

云南大学软件学院 实验报告课程： 数据库原理与实用技术实验 学期： 任课教师： 专业： 学号： 姓名： 成绩： 实验2使用向导创建并管理数据库一、实验目的二、实验内容SQL Server 2008数据库平台1. 使用企业管理器创建如下数据库：（截图）2. 使用企业管理器创建Employee数据库表：（截图）3. 练习生成Employee数据库脚本“employee.sql”，并分析和记录下脚本信息。 USE masterGO/* Object: Database Employee Script Date: 03/20/2014 16:49:21 */CREATE DATABASE Employee ON PRIMARY ( NAME = NEmployee, FILENAME = ND:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLDATAEmployee.mdf , SIZE = 10240KB , MAXSIZE = 51200KB , FILEGROWTH = 10%) LOG ON ( NAME = NEmployee_log, FILENAME = ND:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLDATAEmployee_log.ldf , SIZE = 5120KB , MAXSIZE = 25600KB , FILEGROWTH = 1024KB )GOALTER DATABASE Employee SET COMPATIBILITY_LEVEL = 100GOIF (1 = FULLTEXTSERVICEPROPERTY(IsFullTextInstalled)beginEXEC Employee.dbo.sp_fulltext_database action = enableendGOALTER DATABASE Employee SET ANSI_NULL_DEFAULT OFFGOALTER DATABASE Employee SET ANSI_NULLS OFFGOALTER DATABASE Employee SET ANSI_PADDING OFFGOALTER DATABASE Employee SET ANSI_WARNINGS OFFGOALTER DATABASE Employee SET ARITHABORT OFFGOALTER DATABASE Employee SET AUTO_CLOSE OFFGOALTER DATABASE Employee SET AUTO_CREATE_STATISTICS ONGOALTER DATABASE Employee SET AUTO_SHRINK OFFGOALTER DATABASE Employee SET AUTO_UPDATE_STATISTICS ONGOALTER DATABASE Employee SET CURSOR_CLOSE_ON_COMMIT OFFGOALTER DATABASE Employee SET CURSOR_DEFAULT GLOBALGOALTER DATABASE Employee SET CONCAT_NULL_YIELDS_NULL OFFGOALTER DATABASE Employee SET NUMERIC_ROUNDABORT OFFGOALTER DATABASE Employee SET QUOTED_IDENTIFIER OFFGOALTER DATABASE Employee SET RECURSIVE_TRIGGERS OFFGOALTER DATABASE Employee SET DISABLE_BROKERGOALTER DATABASE Employee SET AUTO_UPDATE_STATISTICS_ASYNC OFFGOALTER DATABASE Employee SET DATE_CORRELATION_OPTIMIZATION OFFGOALTER DATABASE Employee SET TRUSTWORTHY OFFGOALTER DATABASE Employee SET ALLOW_SNAPSHOT_ISOLATION OFFGOALTER DATABASE Employee SET PARAMETERIZATION SIMPLEGOALTER DATABASE Employee SET READ_COMMITTED_SNAPSHOT OFFGOALTER DATABASE Employee SET HONOR_BROKER_PRIORITY OFFGOALTER DATABASE Employee SET READ_WRITEGOALTER DATABASE Employee SET RECOVERY FULLGOALTER DATABASE Employee SET MULTI_USERGOALTER DATABASE Employee SET PAGE_VERIFY CHECKSUMGOALTER DATABASE Employee SET DB_CHAINING OFFGOEXEC sys.sp_db_vardecimal_storage_format NEmployee, NONGOUSE EmployeeGO/* Object: Table dbo.salary Script Date: 03/20/2014 16:49:22 */SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE dbo.salary(pno char(6) NOT NULL,base decimal(18, 0) NULL,Bonus decimal(18, 0) NULL,Month int NOT NULL,Fact nchar(10) NULL, CONSTRAINT PK_salary PRIMARY KEY CLUSTERED (pno ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON PRIMARY) ON PRIMARYGOSET ANSI_PADDING OFFGO/* Object: Table dbo.person Script Date: 03/20/2014 16:49:22 */SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE dbo.person(pno nchar(6) NOT NULL,pname varchar(10) NOT NULL,Sex char(2) NOT NULL,birthday datetime NULL,prof varchar(10) NULL,Deptno char(4) NOT NULL, CONSTRAINT PK_person PRIMARY KEY CLUSTERED (pno ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON PRIMARY) ON PRIMARYGOSET ANSI_PADDING OFFGO/* Object: Table dbo.department Script Date: 03/20/2014 16:49:22 */SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE dbo.department(Deptno char(4) NOT NULL,Dname varchar(10) NOT NULL, CONSTRAINT PK_department PRIMARY KEY CLUSTERED (Deptno ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON PRIMARY) ON PRIMARYGOS