==============================================================================
产品表 字段 可在 SQL Server 2000 下执行 去掉// 列如要把//产品类别 //产品名称
这些去掉哦
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Product]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Product]
GO
CREATE TABLE [dbo].[Product] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[Product_class] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , //产品类别
[Product_name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , //产品名称
[Product_in] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , //产品价格
[Product_gain] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Product_spec] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , //规格
[Product_unit] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , //单位
[Product_remark] [ntext] COLLATE Chinese_PRC_CI_AS NULL , //备注
[Product_explain] [ntext] COLLATE Chinese_PRC_CI_AS NULL , //产品说明
[Product_picture] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,//产品图片
[Product_auditing] [bit] NOT NULL , //是(如果选中的话将直接发布)
[index_show] [bit] NOT NULL , //首页显示
[join_date] [smalldatetime] NULL , //录入时间
[change_date] [smalldatetime] NULL , //修改时间
[hit] [int] NULL , //点击次数
[picnum] [char] (10) COLLATE Chinese_PRC_CI_AS NULL //图片数量
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
==========================================================================