一、数据表结构
CREATE TABLE [Magzine] ( [M_ID] [int] IDENTITY (1, 1) NOT NULL , [P_ID] [int] NULL , [P_C_ID] [int] NULL , [P_Name] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL , [P_Key] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [P_SingleIntro] [nvarchar] (1000) COLLATE Chinese_PRC_CI_AS NULL , [P_Intro] [ntext] COLLATE Chinese_PRC_CI_AS NULL , [P_Order] [float] NULL , [P_Cate] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [P_SysCate] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NULL , [P_C_Name] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL , [P_C_Order] [int] NULL , [P_C_Contact] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL , [P_C_Address] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL , [P_C_Tel] [nvarchar] (80) COLLATE Chinese_PRC_CI_AS NULL , [P_C_Email] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [P_C_Fax] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [P_C_Web] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL , [P_TopTime] [smalldatetime] NULL , [P_InsertTime] [smalldatetime] NULL , [P_ModifyTime] [smalldatetime] NULL , [P_BigImage] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL , [P_SmallImage] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL , [P_User] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [P_CheckState] [int] NULL , [P_CheckInfo] [nvarchar] (80) COLLATE Chinese_PRC_CI_AS NULL , [P_Price] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [P_OtherState] [int] NULL , [M_ZipCode] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [M_PrintImage] [nvarchar] (300) COLLATE Chinese_PRC_CI_AS NULL , [M_Year] [int] NULL , [M_Month] [int] NULL , [M_Term] [int] NULL , [M_Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [M_SubmitDate] [smalldatetime] NOT NULL CONSTRAINT [DF__Magzine__M_Submi__284DF453] DEFAULT (getdate()), [IsUse] [smallint] NOT NULL CONSTRAINT [DF__Magzine__IsUse__2942188C] DEFAULT (0), [F1] [int] NULL , [F2] [int] NULL , [F3] [nvarchar] (300) COLLATE Chinese_PRC_CI_AS NULL , [F4] [nvarchar] (300) COLLATE Chinese_PRC_CI_AS NULL , [C_TelCode] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL , CONSTRAINT [PK_magzine] PRIMARY KEY CLUSTERED ( [M_ID] ) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]GO
二、数据如下
SET Identity_Insert dbo.Magzine ONINSERT INTO dbo.Magzine( M_ID,P_ID,P_C_ID,P_Name, P_Key,P_SingleIntro,P_Intro,P_Order, P_Cate,P_SysCate,P_C_Name,P_C_Order, P_C_Contact,P_C_Address,P_C_Tel,P_C_Email, P_C_Fax,P_C_Web,P_TopTime,P_InsertTime, P_ModifyTime,P_BigImage,P_SmallImage,P_User, P_CheckState,P_CheckInfo,P_Price,P_OtherState, M_ZipCode,M_PrintImage,M_Year,M_Month, M_Term,M_Name,M_SubmitDate,IsUse, F1,F2,F3,F4, C_TelCode)VALUES ( 1,1,119, '长白山老人参119','人参','简介：长白山的百年人参119','详细介绍119', 120,'','种子、种苗','长白山第119人参种植厂', 100,'胡119涛','中南海办公楼1号','010-51888888', 'hu1tao@cn.com','010-88888888','http://www.china.com','2006-07-14 14:54:00.000', '2006-08-13 14:54:00.000','2006-08-03 14:54:00.000','http://www.vegnet.com.cn/images/ploy_d.jpg','http://www.vegnet.com.cn/images/ploy.jpg', '欢迎与邀月交流,net技术与软件架构',1,'正确','981￥/克', 1,'313200','http://www.vegnet.com.cn/images/ploy_d.jpg',0, 1,32,'蔬菜网杂志0年1月','2006-10-11 14:54:00.000', 1,0,0,NULL, NULL,'010')GOINSERT INTO dbo.Magzine( M_ID,P_ID,P_C_ID,P_Name, P_Key,P_SingleIntro,P_Intro,P_Order, P_Cate,P_SysCate,P_C_Name,P_C_Order, P_C_Contact,P_C_Address,P_C_Tel,P_C_Email, P_C_Fax,P_C_Web,P_TopTime,P_InsertTime, P_ModifyTime,P_BigImage,P_SmallImage,P_User, P_CheckState,P_CheckInfo,P_Price,P_OtherState, M_ZipCode,M_PrintImage,M_Year,M_Month, M_Term,M_Name,M_SubmitDate,IsUse, F1,F2,F3,F4, C_TelCode)VALUES ( 2,2,127, '长白山老人参127','人参','简介：长白山的百年人参127','详细介绍127', 120,'','肥料农药','长白山第127人参种植厂', 100,'胡127涛','中南海办公楼1号','010-51888888', 'hu2tao@cn.com','010-88888888','http://www.china.com','2006-07-06 14:54:00.000', '2006-08-05 14:54:00.000','2006-07-26 14:54:00.000','http://www.vegnet.com.cn/images/ploy_d.jpg','http://www.vegnet.com.cn/images/ploy.jpg', '欢迎与邀月交流,net技术与软件架构',1,'正确','973￥/克', 1,'313200','http://www.vegnet.com.cn/images/ploy_d.jpg',0, 1,32,'蔬菜网杂志0年1月','2006-10-11 14:54:00.000', 1,0,0,NULL, NULL,'010')GOINSERT INTO dbo.Magzine( M_ID,P_ID,P_C_ID,P_Name, P_Key,P_SingleIntro,P_Intro,P_Order, P_Cate,P_SysCate,P_C_Name,P_C_Order, P_C_Contact,P_C_Address,P_C_Tel,P_C_Email, P_C_Fax,P_C_Web,P_TopTime,P_InsertTime, P_ModifyTime,P_BigImage,P_SmallImage,P_User, P_CheckState,P_CheckInfo,P_Price,P_OtherState, M_ZipCode,M_PrintImage,M_Year,M_Month, M_Term,M_Name,M_SubmitDate,IsUse, F1,F2,F3,F4, C_TelCode)VALUES ( 3,3,116, '长白山老人参116','人参','简介：长白山的百年人参116','详细介绍116', 120,'','蔬菜基地','长白山第116人参种植厂', 100,'胡116涛','中南海办公楼1号','010-51888888', 'hu3tao@cn.com','010-88888888','http://www.china.com','2006-07-17 14:54:00.000', '2006-08-16 14:54:00.000','2006-08-06 14:54:00.000','http://www.vegnet.com.cn/images/ploy_d.jpg','http://www.vegnet.com.cn/images/ploy.jpg', 'test333',1,'正确','984￥/克', 1,'313200','http://www.vegnet.com.cn/images/ploy_d.jpg',0, 1,32,'蔬菜网杂志0年1月','2006-10-11 14:54:00.000', 1,0,0,NULL, NULL,'010')GOINSERT INTO dbo.Magzine( M_ID,P_ID,P_C_ID,P_Name, P_Key,P_SingleIntro,P_Intro,P_Order, P_Cate,P_SysCate,P_C_Name,P_C_Order, P_C_Contact,P_C_Address,P_C_Tel,P_C_Email, P_C_Fax,P_C_Web,P_TopTime,P_InsertTime, P_ModifyTime,P_BigImage,P_SmallImage,P_User, P_CheckState,P_CheckInfo,P_Price,P_OtherState, M_ZipCode,M_PrintImage,M_Year,M_Month, M_Term,M_Name,M_SubmitDate,IsUse, F1,F2,F3,F4, C_TelCode)VALUES ( 5,5,122, '长白山老人参122','人参','简介：长白山的百年人参122','详细介绍122', 120,'','蔬菜基地','长白山第122人参种植厂', 100,'胡122涛','中南海办公楼1号','010-51888888', 'hu5tao@cn.com','010-88888888','http://www.china.com','2006-07-11 14:54:00.000', '2006-08-10 14:54:00.000','2006-07-31 14:54:00.000','http://www.vegnet.com.cn/images/ploy_d.jpg','http://www.vegnet.com.cn/images/ploy.jpg', 'test333',1,'正确','978￥/克', 1,'313200','http://www.vegnet.com.cn/images/ploy_d.jpg',0, 1,32,'蔬菜网杂志0年1月','2006-10-11 14:54:00.000', 1,0,0,NULL,