⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 create_db_template.sql

📁 MsSQL通用数据库创建程序源码 ,程序的功能主要是在Delphi中利用程序创建MsSQL通用数据库
💻 SQL
📖 第 1 页 / 共 3 页
字号:
🔍
123 
exec sp_dboption N'$DB_NAME$', N'autoclose', N'false'
GO

exec sp_dboption N'$DB_NAME$', N'bulkcopy', N'false'
GO

exec sp_dboption N'$DB_NAME$', N'trunc. log', N'false'
GO

exec sp_dboption N'$DB_NAME$', N'torn page detection', N'false'
GO

exec sp_dboption N'$DB_NAME$', N'read only', N'false'
GO

exec sp_dboption N'$DB_NAME$', N'dbo use', N'false'
GO

exec sp_dboption N'$DB_NAME$', N'single', N'false'
GO

exec sp_dboption N'$DB_NAME$', N'autoshrink', N'false'
GO

exec sp_dboption N'$DB_NAME$', N'ANSI null default', N'false'
GO

exec sp_dboption N'$DB_NAME$', N'recursive triggers', N'false'
GO

exec sp_dboption N'$DB_NAME$', N'ANSI nulls', N'false'
GO

exec sp_dboption N'$DB_NAME$', N'concat null yields null', N'false'
GO

exec sp_dboption N'$DB_NAME$', N'cursor close on commit', N'false'
GO

exec sp_dboption N'$DB_NAME$', N'default to local cursor', N'false'
GO

exec sp_dboption N'$DB_NAME$', N'quoted identifier', N'false'
GO

exec sp_dboption N'$DB_NAME$', N'ANSI warnings', N'false'
GO

exec sp_dboption N'$DB_NAME$', N'auto create statistics', N'true'
GO

exec sp_dboption N'$DB_NAME$', N'auto update statistics', N'true'
GO

if( (@@microsoftversion / power(2, 24) = 8) and (@@microsoftversion & 0xffff >= 724) )
	exec sp_dboption N'$DB_NAME$', N'db chaining', N'false'
GO

use [$DB_NAME$]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_考场信息表_考点信息表]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[考场信息表] DROP CONSTRAINT FK_考场信息表_考点信息表
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_任课教师表_考点信息表]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[任课教师表] DROP CONSTRAINT FK_任课教师表_考点信息表
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_答案附件表_考生考试表]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[答案附件表] DROP CONSTRAINT FK_答案附件表_考生考试表
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_考生试卷表_考生考试表]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[考生试卷表] DROP CONSTRAINT FK_考生试卷表_考生考试表
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_教师课程表_课程代码表]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[教师课程表] DROP CONSTRAINT FK_教师课程表_课程代码表
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_题型表_课程代码表]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[题型表] DROP CONSTRAINT FK_题型表_课程代码表
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_知识点表_课程代码表]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[知识点表] DROP CONSTRAINT FK_知识点表_课程代码表
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_教师课程表_任课教师表]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[教师课程表] DROP CONSTRAINT FK_教师课程表_任课教师表
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_题库表_题型表]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[题库表] DROP CONSTRAINT FK_题库表_题型表
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_备选答案表_题库表]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[备选答案表] DROP CONSTRAINT FK_备选答案表_题库表
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_题库表_题库表]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[题库表] DROP CONSTRAINT FK_题库表_题库表
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_题库附件表_题库表]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[题库附件表] DROP CONSTRAINT FK_题库附件表_题库表
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_改卷程序表_题库附件表]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[改卷程序表] DROP CONSTRAINT FK_改卷程序表_题库附件表
GO

/****** 对象: 存储过程 dbo.sp_copy_tmp_sjszb    脚本日期: 2008-12-24 19:42:40 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_copy_tmp_sjszb]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_copy_tmp_sjszb]
GO

/****** 对象: 存储过程 dbo.sp_update_ks_state    脚本日期: 2008-12-24 19:42:40 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_update_ks_state]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_update_ks_state]
GO

/****** 对象: 视图 dbo.VIEW_主观题成绩表    脚本日期: 2008-12-24 19:42:40 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[VIEW_主观题成绩表]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[VIEW_主观题成绩表]
GO

/****** 对象: 视图 dbo.VIEW_客观题成绩表    脚本日期: 2008-12-24 19:42:40 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[VIEW_客观题成绩表]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[VIEW_客观题成绩表]
GO

/****** 对象: 视图 dbo.VIEW_教师任课信息    脚本日期: 2008-12-24 19:42:40 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[VIEW_教师任课信息]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[VIEW_教师任课信息]
GO

/****** 对象: 视图 dbo.VIEW_题型信息    脚本日期: 2008-12-24 19:42:40 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[VIEW_题型信息]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[VIEW_题型信息]
GO

/****** 对象: 视图 dbo.VIEW_题型知识点难易度题量表    脚本日期: 2008-12-24 19:42:40 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[VIEW_题型知识点难易度题量表]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[VIEW_题型知识点难易度题量表]
GO

/****** 对象: 视图 dbo.VIEW_已考完考生表    脚本日期: 2008-12-24 19:42:40 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[VIEW_已考完考生表]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[VIEW_已考完考生表]
GO

/****** 对象: 视图 dbo.VIEW_未开考考生表    脚本日期: 2008-12-24 19:42:40 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[VIEW_未开考考生表]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[VIEW_未开考考生表]
GO

/****** 对象: 视图 dbo.VIEW_正在考试考生表    脚本日期: 2008-12-24 19:42:40 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[VIEW_正在考试考生表]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[VIEW_正在考试考生表]
GO

/****** 对象: 视图 dbo.VIEW_考生考试表    脚本日期: 2008-12-24 19:42:40 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[VIEW_考生考试表]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[VIEW_考生考试表]
GO

/****** 对象: 视图 dbo.VIEW_舞弊考生表    脚本日期: 2008-12-24 19:42:40 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[VIEW_舞弊考生表]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[VIEW_舞弊考生表]
GO

/****** 对象: 表 [dbo].[改卷程序表]    脚本日期: 2008-12-24 19:42:40 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[改卷程序表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[改卷程序表]
GO

/****** 对象: 表 [dbo].[备选答案表]    脚本日期: 2008-12-24 19:42:40 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[备选答案表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[备选答案表]
GO

/****** 对象: 表 [dbo].[题库附件表]    脚本日期: 2008-12-24 19:42:40 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[题库附件表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[题库附件表]
GO

/****** 对象: 表 [dbo].[教师课程表]    脚本日期: 2008-12-24 19:42:40 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[教师课程表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[教师课程表]
GO

/****** 对象: 表 [dbo].[题库表]    脚本日期: 2008-12-24 19:42:40 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[题库表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[题库表]
GO

/****** 对象: 表 [dbo].[任课教师表]    脚本日期: 2008-12-24 19:42:40 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[任课教师表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[任课教师表]
GO

/****** 对象: 表 [dbo].[知识点表]    脚本日期: 2008-12-24 19:42:40 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[知识点表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[知识点表]
GO

/****** 对象: 表 [dbo].[答案附件表]    脚本日期: 2008-12-24 19:42:40 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[答案附件表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[答案附件表]
GO

/****** 对象: 表 [dbo].[考场信息表]    脚本日期: 2008-12-24 19:42:40 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[考场信息表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[考场信息表]
GO

/****** 对象: 表 [dbo].[考生试卷表]    脚本日期: 2008-12-24 19:42:40 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[考生试卷表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[考生试卷表]
GO

/****** 对象: 表 [dbo].[题型表]    脚本日期: 2008-12-24 19:42:40 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[题型表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[题型表]
GO

/****** 对象: 表 [dbo].[InKeyTable]    脚本日期: 2008-12-24 19:42:40 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[InKeyTable]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[InKeyTable]
GO

/****** 对象: 表 [dbo].[tmp_试卷配置表]    脚本日期: 2008-12-24 19:42:40 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tmp_试卷配置表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tmp_试卷配置表]
GO

/****** 对象: 表 [dbo].[准考证表]    脚本日期: 2008-12-24 19:42:40 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[准考证表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[准考证表]
GO

/****** 对象: 表 [dbo].[客户端IP表]    脚本日期: 2008-12-24 19:42:40 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[客户端IP表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[客户端IP表]
GO

/****** 对象: 表 [dbo].[操作员表]    脚本日期: 2008-12-24 19:42:40 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[操作员表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[操作员表]
GO

/****** 对象: 表 [dbo].[操作说明表]    脚本日期: 2008-12-24 19:42:40 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[操作说明表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[操作说明表]
GO

/****** 对象: 表 [dbo].[教师改卷题型表]    脚本日期: 2008-12-24 19:42:40 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[教师改卷题型表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[教师改卷题型表]
GO

/****** 对象: 表 [dbo].[考点信息表]    脚本日期: 2008-12-24 19:42:40 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[考点信息表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[考点信息表]
GO

/****** 对象: 表 [dbo].[考生信息表]    脚本日期: 2008-12-24 19:42:40 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[考生信息表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[考生信息表]
GO

/****** 对象: 表 [dbo].[考生考试表]    脚本日期: 2008-12-24 19:42:40 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[考生考试表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[考生考试表]
GO

/****** 对象: 表 [dbo].[考试配置表]    脚本日期: 2008-12-24 19:42:40 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[考试配置表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[考试配置表]
GO

/****** 对象: 表 [dbo].[试卷配置表]    脚本日期: 2008-12-24 19:42:40 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[试卷配置表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[试卷配置表]
GO

/****** 对象: 表 [dbo].[课程代码表]    脚本日期: 2008-12-24 19:42:40 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[课程代码表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[课程代码表]
GO

/****** 对象: 表 [dbo].[题型类别表]    脚本日期: 2008-12-24 19:42:40 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[题型类别表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[题型类别表]
GO

if not exists (select * from master.dbo.syslogins where loginname = N'$SA_NAME$')
BEGIN
	declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'master', @loginlang = N'简体中文'
	if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)
		select @logindb = N'master'
	if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')
		select @loginlang = @@language
	exec sp_addlogin N'$SA_NAME$', '$SA_PWD$', @logindb, @loginlang
END
GO

if not exists (select * from dbo.sysusers where name = N'$SA_NAME$' and uid < 16382)
	EXEC sp_grantdbaccess N'$SA_NAME$'
GO

exec sp_addrolemember N'db_owner', N'$SA_NAME$'
GO

/****** 对象: 表 [dbo].[InKeyTable]    脚本日期: 2008-12-24 19:42:42 ******/
CREATE TABLE [dbo].[InKeyTable] (
	[Tkb_ID] [int] NOT NULL ,
	[Tkfjb_ID] [int] NOT NULL ,
	[ID] [int] IDENTITY (1, 1) NOT NULL 
) ON [PRIMARY]
GO

/****** 对象: 表 [dbo].[tmp_试卷配置表]    脚本日期: 2008-12-24 19:42:42 ******/
CREATE TABLE [dbo].[tmp_试卷配置表] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[课程号] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[题型] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[知识点] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[难易度] [varchar] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[现有题量] [int] NULL ,
	[小题数量] [int] NULL ,
	[题量] [int] NULL ,
	[分数] [decimal](5, 1) NULL ,
	[题号] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** 对象: 表 [dbo].[准考证表]    脚本日期: 2008-12-24 19:42:43 ******/
CREATE TABLE [dbo].[准考证表] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[准考证号] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[考试密码] [varchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[学号] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** 对象: 表 [dbo].[客户端IP表]    脚本日期: 2008-12-24 19:42:43 ******/
CREATE TABLE [dbo].[客户端IP表] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[开始IP] [varchar] (15) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[结束IP] [varchar] (15) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[允许否] [bit] NOT NULL ,
	[备注] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** 对象: 表 [dbo].[操作员表]    脚本日期: 2008-12-24 19:42:43 ******/
CREATE TABLE [dbo].[操作员表] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[操作员ID] [varchar] (3) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[操作员等级] [decimal](18, 0) NULL ,
	[密码] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** 对象: 表 [dbo].[操作说明表]    脚本日期: 2008-12-24 19:42:43 ******/
CREATE TABLE [dbo].[操作说明表] (
	[ID] [int] NOT NULL ,
	[考生须知] [text] COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** 对象: 表 [dbo].[教师改卷题型表]    脚本日期: 2008-12-24 19:42:43 ******/
CREATE TABLE [dbo].[教师改卷题型表] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[教师编号] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[课程号] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[题型] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[学号] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[是否上传] [varchar] (2) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** 对象: 表 [dbo].[考点信息表]    脚本日期: 2008-12-24 19:42:43 ******/
CREATE TABLE [dbo].[考点信息表] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[考点代码] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[考点名称] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[试卷号] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[考试代码] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[状态] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** 对象: 表 [dbo].[考生信息表]    脚本日期: 2008-12-24 19:42:43 ******/
CREATE TABLE [dbo].[考生信息表] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[学号] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[姓名] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[性别] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[院系] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[专业] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[班级] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[密码] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[所属考点] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** 对象: 表 [dbo].[考生考试表]    脚本日期: 2008-12-24 19:42:43 ******/
CREATE TABLE [dbo].[考生考试表] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[学号] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[课程号] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[开考时间] [smalldatetime] NULL ,
	[交卷时间] [smalldatetime] NULL ,
	[考试时长] [decimal](18, 0) NULL ,
	[成绩] [decimal](18, 1) NULL ,
	[考试状态] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[考生机器名] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[考生IP] [varchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[试卷生成时间] [smalldatetime] NOT NULL
123

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -