sql脚本语言.txt

学生管理系统的课程设计报告

IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'学生')
	DROP DATABASE [学生]
GO

CREATE DATABASE [学生]  ON (NAME = N'学生_Data', FILENAME = N'C:\Documents and Settings\Administrator\桌面\计算机6班叶福永\数据库文件\学生_Data.MDF' , SIZE = 2, FILEGROWTH = 10%) LOG ON (NAME = N'学生_Log', FILENAME = N'C:\Documents and Settings\Administrator\桌面\计算机6班叶福永\数据库文件\学生_Log.LDF' , SIZE = 1, FILEGROWTH = 10%)
 COLLATE Chinese_PRC_CI_AS
GO

exec sp_dboption N'学生', N'autoclose', N'false'
GO

exec sp_dboption N'学生', N'bulkcopy', N'false'
GO

exec sp_dboption N'学生', N'trunc. log', N'true'
GO

exec sp_dboption N'学生', N'torn page detection', N'false'
GO

exec sp_dboption N'学生', N'read only', N'false'
GO

exec sp_dboption N'学生', N'dbo use', N'false'
GO

exec sp_dboption N'学生', N'single', N'false'
GO

exec sp_dboption N'学生', N'autoshrink', N'true'
GO

exec sp_dboption N'学生', N'ANSI null default', N'false'
GO

exec sp_dboption N'学生', N'recursive triggers', N'false'
GO

exec sp_dboption N'学生', N'ANSI nulls', N'false'
GO

exec sp_dboption N'学生', N'concat null yields null', N'false'
GO

exec sp_dboption N'学生', N'cursor close on commit', N'false'
GO

exec sp_dboption N'学生', N'default to local cursor', N'false'
GO

exec sp_dboption N'学生', N'quoted identifier', N'false'
GO

exec sp_dboption N'学生', N'ANSI warnings', N'false'
GO

exec sp_dboption N'学生', N'auto create statistics', N'true'
GO

exec sp_dboption N'学生', N'auto update statistics', N'true'
GO

use [学生]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[users]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[users]
GO
/////////////////////////////////////////
CREATE TABLE [dbo].[users] (
	[ID] [char] (12) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[name] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[passwd] [char] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[type] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[description] [char] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[reward]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[reward]
GO

CREATE TABLE [dbo].[reward] (
	[RID] [int] NOT NULL ,
	[studentID] [char] (11) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[recdate] [datetime] NOT NULL ,
	[reward] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[description] [char] (100) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO