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

📄 sql.txt

📁 基于VB开发的一个连接数据库的人口管理系统 其中包括程序设计报告 使用说明等 源码
💻 TXT
📖 第 1 页 / 共 3 页
字号:
🔍
123 
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[View_TXFS]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[View_TXFS]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[View_ryxz]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[View_ryxz]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[View_jhsyxz]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[View_jhsyxz]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Table_HKB]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Table_HKB]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Table_HKB_TXFS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Table_HKB_TXFS]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Table_HYXXB]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Table_HYXXB]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Table_JHSY_BXB]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Table_JHSY_BXB]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Table_JHSY_BYSB]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Table_JHSY_BYSB]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Table_JHSY_FJB]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Table_JHSY_FJB]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Table_JHSY_JFB]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Table_JHSY_JFB]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Table_JHSY_JSB]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Table_JHSY_JSB]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Table_JHSY_LDB]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Table_JHSY_LDB]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Table_JHSY_SYSB]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Table_JHSY_SYSB]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Table_JHSY_YCSB]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Table_JHSY_YCSB]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Table_JHSY_YFJCB]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Table_JHSY_YFJCB]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Table_JHSY_YFXXB]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Table_JHSY_YFXXB]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Table_JHSY_YJFFB]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Table_JHSY_YJFFB]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Table_JHSY_ZFXXB]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Table_JHSY_ZFXXB]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Table_SQJZ_CJRB]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Table_SQJZ_CJRB]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Table_SQJZ_DBRY]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Table_SQJZ_DBRY]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Table_SQJZ_GZDX]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Table_SQJZ_GZDX]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Table_SQJZ_LLRY]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Table_SQJZ_LLRY]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Table_SQJZ_OLD]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Table_SQJZ_OLD]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Table_SQJZ_SYRY]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Table_SQJZ_SYRY]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Table_SQJZ_YFRY]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Table_SQJZ_YFRY]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Table_ZZRKB]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Table_ZZRKB]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Table_ZZRK_CLXX]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Table_ZZRK_CLXX]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Table_ZZRK_CZFW]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Table_ZZRK_CZFW]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Table_ZZRK_CZRXX]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Table_ZZRK_CZRXX]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Table_ZZRK_SHCZFW]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Table_ZZRK_SHCZFW]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Table_ZZRK_ZKXX]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Table_ZZRK_ZKXX]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Table_ZZRK_XDRKB]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Table_ZZRK_XDRKB]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Table_xxwhb]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Table_xxwhb]
GO

CREATE TABLE [dbo].[Table_HKB] (
	[ID] [decimal](18, 0) NULL ,
	[户口簿号] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[户口类型] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[楼号] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[户号] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[户主姓名] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[联系电话1] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[家庭地址] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
	[总人数] [int] NULL ,
	[男子数] [int] NULL ,
	[女子数] [int] NULL ,
	[月总收入] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[经济状况] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[住所类型] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[家庭备注] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[人口编号] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[姓名] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[曾用名] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[与户主关系] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[身份证号] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[签发机关] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[签发日期] [datetime] NULL ,
	[出生日期] [datetime] NULL ,
	[年龄] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[出生地] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
	[性别] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[身高] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[血型] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[健康状况] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[户籍所在地] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[民族] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[籍贯] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[住址] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[联系电话2] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[其他住址] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[文化程度] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[婚姻状况] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[兵役状况] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[宗教信仰] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[政治面貌] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[职业] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[服务处所] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[备注] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[迁入日期] [datetime] NULL ,
	[原地址] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[迁入类别] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[迁入原因] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[迁出日期] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[迁出地址] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[迁出类型] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[迁出原因] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[登记时间] [datetime] NULL ,
	[户籍状况] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[已亡故] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[死亡日期] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[死亡原因] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[户口已注销] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[注销日期] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[注销原因] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Table_HKB_TXFS] (
	[人口编号] [decimal](18, 0) NULL ,
	[姓名] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[楼号] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[户号] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[住址] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[电话] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[传真] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[呼机] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[E_mail] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Table_HYXXB] (
	[育妇编码] [decimal](18, 0) NOT NULL ,
	[结婚年月] [datetime] NULL ,
	[节育年月] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[绝经年月] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[独生证] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[领取年月] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[注销年月] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[备注] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Table_JHSY_BXB] (
	[育妇编码] [decimal](18, 0) NULL ,
	[保险名称] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[保险份数] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[起始日期] [datetime] NULL ,
	[结束日期] [datetime] NULL ,
	[备注] [char] (100) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Table_JHSY_BYSB] (
	[育妇编码] [decimal](18, 0) NOT NULL ,
	[避孕原因] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[避孕方法] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[避孕起始日期] [datetime] NULL ,
	[避孕终止日期] [datetime] NULL ,
	[措施上报年月] [datetime] NULL ,
	[取环上报年月] [datetime] NULL ,
	[避孕状态] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[未避孕原因] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[施术单位] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[备注] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Table_JHSY_FJB] (
	[育妇编码] [decimal](18, 0) NOT NULL ,
	[名称] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[内容] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Table_JHSY_JFB] (
	[育妇编码] [decimal](18, 0) NOT NULL ,
	[奖罚类型] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[奖罚年月] [datetime] NULL ,
	[奖罚原因] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[应奖罚金额] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[实奖罚金额] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[奖罚决定书号] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[备注] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Table_JHSY_JSB] (
	[育妇编码] [decimal](18, 0) NOT NULL ,
	[内容] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Table_JHSY_LDB] (
	[育妇编码] [decimal](18, 0) NULL ,
123

⌨️ 快捷键说明

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