ASP企业员工管理系统设计与实现

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mytree]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[mytree] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[praise]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[praise] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[punish]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[punish] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_answerfile]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[t_answerfile] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_attent_month]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[t_attent_month] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_document]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[t_document] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_education]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[t_education] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_education_resume]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[t_education_resume] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_experience]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[t_experience] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_experience_resume]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[t_experience_resume] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_family]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[t_family] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_family_resume]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[t_family_resume] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_file]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[t_file] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_limit]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[t_limit] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_notice]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[t_notice] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_plane_month]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[t_plane_month] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_praise]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[t_praise] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_precontract]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[t_precontract] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_resume]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[t_resume] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_sendfile]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[t_sendfile] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_task]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[t_task] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_text]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[t_text] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_ts]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[t_ts] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_user]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[t_user] GO if exists (select * from dbo.sy�