HiShop网上商城系统

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[F_GetHelpCode]') and xtype in (N'FN', N'IF', N'TF')) drop function [dbo].[F_GetHelpCode] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Hishop_splitstr]') and xtype in (N'FN', N'IF', N'TF')) drop function [dbo].[Hishop_splitstr] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[f_ch2py]') and xtype in (N'FN', N'IF', N'TF')) drop function [dbo].[f_ch2py] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Hishop_AddNewSelectValue]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[Hishop_AddNewSelectValue] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Hishop_Backup_DB]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[Hishop_Backup_DB] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Hishop_CleanGwc]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[Hishop_CleanGwc] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Hishop_CleanGwc_STONE]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[Hishop_CleanGwc_STONE] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Hishop_Clearup_BY_MS]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[Hishop_Clearup_BY_MS] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Hishop_CreatOrder]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[Hishop_CreatOrder] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Hishop_GetUserInfo]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[Hishop_GetUserInfo] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Hishop_GetdefaultADS]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[Hishop_GetdefaultADS] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Hishop_GetgoodsADS]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[Hishop_GetgoodsADS] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Hishop_Getgoodstype2ADS]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[Hishop_Getgoodstype2ADS] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Hishop_Getgoodstype3ADS]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[Hishop_Getgoodstype3ADS] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Hishop_GetgoodstypeADS]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[Hishop_GetgoodstypeADS] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Hishop_GetotherADS]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[Hishop_GetotherADS] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Hishop_Getuserselect]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[Hishop_Getuserselect] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Hishop_Gwc2Orderitem]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[Hishop_Gwc2Orderitem] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Hishop_SetUserinfoXX]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[Hishop_SetUserinfoXX] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Hishop_conver_1to2]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[Hishop_conver_1to2] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Hishop_conver_1to3]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[Hishop_conver_1to3] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Hishop_conver_2to1]') and OBJECTPR�