阿里巴巴全部行业分类

if exists (select * from sysobjects where id = OBJECT_ID('[K_COM_Company_Trade]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) 
DROP TABLE [K_COM_Company_Trade]

CREATE TABLE [K_COM_Company_Trade] (
[id] [int]  NULL,
[pid] [int]  NULL,
[name] [nvarchar]  (50) NULL,
[levels] [int]  NULL,
[usertype] [int]  NULL,
[displayorder] [int]  NULL)

INSERT [K_COM_Company_Trade] ([id],[pid],[name],[levels],[usertype],[displayorder]) VALUES ( 1035082,1032244,N'中高频放大三极管',2,0,0)
INSERT [K_COM_Company_Trade] ([id],[pid],[name],[levels],[usertype],[displayorder]) VALUES ( 1035003,10234,N'LED数码管',2,0,0)
INSERT [K_COM_Company_Trade] ([id],[pid],[name],[levels],[usertype],[displayorder]) VALUES ( 3422,53,N'有线线缆设备',1,0,0)
INSERT [K_COM_Company_Trade] ([id],[pid],[name],[levels],[usertype],[displayorder]) VALUES ( 1036315,2323,N'酒类包装',2,0,0)
INSERT [K_COM_Company_Trade] ([id],[pid],[name],[levels],[usertype],[displayorder]) VALUES ( 7311153,801384,N'彩喷纸',2,0,0)
INSERT [K_COM_Company_Trade] ([id],[pid],[name],[levels],[usertype],[displayorder]) VALUES ( 1032683,2110,N'屏风',2,0,0)
INSERT [K_COM_Company_Trade] ([id],[pid],[name],[levels],[usertype],[displayorder]) VALUES ( 4149385,4231359,N'网卡',2,0,0)
INSERT [K_COM_Company_Trade] ([id],[pid],[name],[levels],[usertype],[displayorder]) VALUES ( 1035033,10233,N'电热管、发热管',2,0,0)
INSERT [K_COM_Company_Trade] ([id],[pid],[name],[levels],[usertype],[displayorder]) VALUES ( 1031863,10157,N'肩垫',2,0,0)
INSERT [K_COM_Company_Trade] ([id],[pid],[name],[levels],[usertype],[displayorder]) VALUES ( 1034465,10177,N'EVA鞋底',2,0,0)
INSERT [K_COM_Company_Trade] ([id],[pid],[name],[levels],[usertype],[displayorder]) VALUES ( 1034253,1101,N'沉淀池',2,0,0)
INSERT [K_COM_Company_Trade] ([id],[pid],[name],[levels],[usertype],[displayorder]) VALUES ( 1032480,1426,N'专用机床',2,0,0)
INSERT [K_COM_Company_Trade] ([id],[pid],[name],[levels],[usertype],[displayorder]) VALUES ( 1036123,1032476,N'方箱',2,0,0)
INSERT [K_COM_Company_Trade] ([id],[pid],[name],[levels],[usertype],[displayorder]) VALUES ( 1033782,511,N'收银台',2,0,0)
INSERT [K_COM_Company_Trade] ([id],[pid],[name],[levels],[usertype],[displayorder]) VALUES ( 1031667,10413,N'吸收器',2,0,0)
INSERT [K_COM_Company_Trade] ([id],[pid],[name],[levels],[usertype],[displayorder]) VALUES ( 28674,9031236,N'磁卡锁',2,0,0)
INSERT [K_COM_Company_Trade] ([id],[pid],[name],[levels],[usertype],[displayorder]) VALUES ( 1033848,1535,N'千分尺',2,0,0)
........... 

 sql文件下载