R_BROKER_PRIORITY OFF
GO
ALTER DATABASE [StudentManagement] SET RECOVERY FULL
GO
ALTER DATABASE [StudentManagement] SET MULTI_USER GO
ALTER DATABASE [StudentManagement] SET PAGE_VERIFY CHECKSUM GO
ALTER DATABASE [StudentManagement] SET DB_CHAINING OFF
GO
ALTER DATABASE [StudentManagement] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) GO
ALTER DATABASE [StudentManagement] SET TARGET_RECOVERY_TIME = 0 SECONDS GO
EXEC sys.sp_db_vardecimal_storage_format N'StudentManagement', N'ON'
GO
USE [StudentManagement]
GO
/****** Object: Table [dbo].[SM_Class] Script Date: 2014/12/28 15:22:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SM_Class]( [SM_id] [int] IDENTITY(1,1) NOT NULL, [SM_name] [varchar](20) NULL, [SM_Grade] [varchar](20) NULL, [SM_Class] [varchar](20) NULL, [SM_Gender] [varchar](5) NULL, [SM_Age] [int] NULL, [SM_OutTime] [datetime] NOT NULL, [SM_Istf] [bit] NOT NULL, CONSTRAINT [PK__SM_Class__D963B824E04B3DFA] PRIMARY KEY CLUSTERED ( [SM_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
USE [master]
GO
ALTER DATABASE [StudentManagement] SET READ_WRITE GO
View Code
这个数据库的脚本可能需要注意的两点
第一、你必须手动建一个“StudentManagement”的数据库,建好数据库之后 在新建查询 里面打上 USE StudentManagement;
第二、在你新建表的同时,你需要确定你的路径在哪里
( NAME = N'StudentManagement_data', FILENAME = N'E:\SQL\StudentManagement.mdf' , SIZE = 10240KB , MAXSIZE = 10240KB , FILEGROWTH = 10%) LOG ON ( NAME = N'StudentManagement_log', FILENAME = N'E:\SQL\StudentManagement,ldf' , SIZE = 5120KB , MAXSIZE = 2048GB , FILEGROWTH = 10240KB ) GO
也就是FILENAME 后面的路径在那个盘下面的那个文件.这个搭建好了之后我相信应该会有数据库了吧 !里面的字段可能不够成熟,希望大家多多指导下。
|