DB_51Aspx/sql语句/20181206数据库.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

USE master;
IF DB_ID('HospitalInformation') IS NOT NULL
	BEGIN
		ALTER DATABASE EduBaseDemo
			SET SINGLE_USER
			WITH ROLLBACK IMMEDIATE;
		DROP DATABASE HospitalInformation;
	END
CREATE DATABASE HospitalInformation
	ON
		(NAME='Datafile'
		,FILENAME='C:\HI\DataFile.mdf')
	LOG ON
		(NAME='Logfile'
		,FILENAME='C:\HI\Logfile.ldf');
GO
USE HospitalInformation;

IF EXISTS(select count(*) from dbo.sysobjects
where xtype='U' and Name = 'Administrator')  --查询表名costSeparateConfig是否存在
	DROP table Administrator     --存在则删除
	GO	--创建新表
	CREATE TABLE Administrator
	(AdministratorNo
		VARCHAR(12)
		NOT NULL
		PRIMARY KEY
	,AdministratorName
		VARCHAR(12)
	,AdministratorPwd
		VARCHAR(20)
	,AdministratorGender
		VARCHAR(2)
	,AdministratorBirthDate
		Date
	)
		
		INSERT Administrator 
	(AdministratorNo,AdministratorName,AdministratorPwd,AdministratorGender,AdministratorBirthDate)
	VALUES
	('01','张三峰','P01','男','1968-01-02')
	,('02','李轩逸','P02','女','1987-09-19')
	,('03','王都快','P03','男','1993-12-18')
	,('04','宋登扫','P04','女','1960-10-20')
	,('05','刘到家','P05','男','1978-06-12')
	
	
	IF EXISTS(select count(*) from dbo.sysobjects
where xtype='U' and Name = 'OneBill')  --查询表名costSeparateConfig是否存在
	DROP table OneBill     --存在则删除
	GO	--创建新表
	CREATE TABLE OneBill
	(OneBillNo
		VARCHAR(12)
		NOT NULL
		PRIMARY KEY
	,OneBillDocNo
		VARCHAR(12)
	,OneBillNurNo
		VARCHAR(12)