renshi.rar_考核系统 VB

use master go IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'人事管理系统') DROP DATABASE [人事管理系统] GO CREATE DATABASE [人事管理系统] GO use [人事管理系统] 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].[员工基本信息表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[员工基本信息表] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[员工录用信息表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[员工录用信息表] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[工作考核信息表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[工作考核信息表] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[工资标准信息表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[工资标准信息表] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[工资计发信息表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[工资计发信息表] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[用户信息表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[用户信息表] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[考勤信息表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[考勤信息表] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[考勤考核信息表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[考勤考核信息表] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[职务信息表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[职务信息表] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[部门信息表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[部门信息表] GO CREATE TABLE [dbo].[员工基本信息表] ( [员工ID] [char] (8) COLLATE Chinese_PRC_CI_AS NOT NULL , [姓名] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [性别] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL , [出生日期] [datetime] NULL , [籍贯] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [民族] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [身份证号] [char] (18) COLLATE Chinese_PRC_CI_AS N�