基于ASP的网上商品交易系统

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tab_manager]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tab_manager] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tab_brand]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tab_brand] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tab_customer]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tab_customer] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tab_kucun]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tab_kucun] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tab_procure]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tab_procure] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tab_rkjz]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tab_rkjz] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tab_rkph]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tab_rkph] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tab_ruku]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tab_ruku] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tab_rukuth]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tab_rukuth] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tab_sell]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tab_sell] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tab_selljz]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tab_selljz] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tab_sellph]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tab_sellph] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tab_sellth]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tab_sellth] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tab_sex]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tab_sex] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tab_supplier]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tab_supplier] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tab_thjz_rk]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tab_thjz_rk] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tab_thjz_xs]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tab_thjz_xs] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tab_thph_rk]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tab_thph_rk] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tab_thph_xs]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tab_thph_xs] GO CREATE TABLE [dbo].[tab_manager] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [manager] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [password] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[tab_brand] ( [ID] [char] (7) COLLATE Chinese_PRC_CI_AS NOT NULL , [spname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [jc] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [cd] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL , [dw] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [gg] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [bz] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [ph] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [pzwh] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [gysname] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [memo] [varchar�