爱迪尔门锁软件 9200t

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TRIGU_DOORS]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) drop trigger [dbo].[TRIGU_DOORS] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TRIGD_JBB]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) drop trigger [dbo].[TRIGD_JBB] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TRIGU_LBQY]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) drop trigger [dbo].[TRIGU_LBQY] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TRIGI_LBQY]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) drop trigger [dbo].[TRIGI_LBQY] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TRIGD_LBQY]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) drop trigger [dbo].[TRIGD_LBQY] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TRIGI_LCQY]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) drop trigger [dbo].[TRIGI_LCQY] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TRIGU_LCQY]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) drop trigger [dbo].[TRIGU_LCQY] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TRIGD_LCQY]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) drop trigger [dbo].[TRIGD_LCQY] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TRIGI_QJQY]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) drop trigger [dbo].[TRIGI_QJQY] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TRIGU_QJQY]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) drop trigger [dbo].[TRIGU_QJQY] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TRIGD_QJQY]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) drop trigger [dbo].[TRIGD_QJQY] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TRIG_I_ROOMSTATUS]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) drop trigger [dbo].[TRIG_I_ROOMSTATUS] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TRIGU_ROOMTYPE]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) drop trigger [dbo].[TRIGU_ROOMTYPE] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TRIGD_SJK1]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) drop trigger [dbo].[TRIGD_SJK1] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AUTOZC]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[AUTOZC] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CANCELCARD]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[CANCELCARD] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CHANGEMY]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[CHANGEMY] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DELETEDATA]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[DELETEDATA] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[EMPTYROOMVIEW]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[EMPTYROOMVIEW] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GETCHNO]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[GETCHNO] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GETCHNO2]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[GETCHNO2] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GETDOORS]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[GETDOORS] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GETJOBID]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[GETJOBID] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GETMAXNUM]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[GETMAXNUM] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GETMY]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[GETMY] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ISEMPTYROOM]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[ISEMPTYROOM] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[NEWNID]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[NEWNID] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[NEWREGNO]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[NEWREGNO] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ROOMSTATE]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[ROOMSTATE] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ROOMSTATEVIEW]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[ROOMSTATEVIEW] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[VALIDROOMINFO]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[VALIDROOMINFO] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BSCODE]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[BSCODE] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BSQY]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[BSQY] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CARDDOOR]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[CARDDOOR] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CARDTYPE]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[CARDTYPE] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DELCARD]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[DELCARD] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DOORS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[DOORS] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[JBB]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[JBB] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[KRK]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[KRK] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[KYQY]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[KYQY] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[LBQY]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[LBQY] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[LCQY]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[LCQY] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MAXNUM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[MAXNUM] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MY]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[MY] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[QJK]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[QJK] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[QJQY]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[QJQY] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[REGID]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[REGID] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ROOMINFO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[ROOMINFO] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ROOMSTATUS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[ROOM