22,210
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE [customer] (
[cat_id] [int] NOT NULL,
[c_id] [int] NOT NULL,
[c_name] [varchar] (250) NOT NULL,
[c_password] [varchar] (20) NOT NULL,
[c_state] [varchar] (20),
[c_province] [varchar] (20),
[c_city] [varchar] (20),
[c_addr] [varchar] (8000),
[c_corporation] [varchar] (250),
[c_fund] [varchar] (20),
[c_brand] [varchar] (30),
[c_year] [varchar] (10),
[c_month] [varchar] (10),
[c_type] [varchar] (20),
[c_product] [varchar] (250),
[c_contacter] [varchar] (250),
[c_phone] [varchar] (20),
[c_fax] [varchar] (20),
[c_postcode] [varchar] (6),
[c_email] [varchar] (250),
[c_web] [varchar] (250),
[c_desc] [varchar] (8000),
[c_date] [datetime] NOT NULL,
[checked] [int],
[c_company] [varchar] (250),
[c_logo] [varchar] (250),
[c_pic] [varchar] (250),
[c_maillist] [int] NOT NULL,
[c_bgphoto] [varchar] (250) NOT NULL,
[c_menu] [varchar] (10) NOT NULL,
[company_code] [varchar] (250),
[en_name] [varchar] (250),
[tax_no] [varchar] (250),
[en_address] [varchar] (8000),
[cn_fa_ren] [varchar] (200),
[en_fa_ren] [varchar] (200),
[fa_ren_sex] [varchar] (1),
[hand_phone] [varchar] (15),
[register] [varchar] (12),
[en_desc] [varchar] (8000),
[grade1] [varchar] (20),
[grade2] [varchar] (20),
[grade3] [varchar] (20),
[grade] [varchar] (20),
PRIMARY KEY([c_name])
)
GO
INSERT INTO [customer] ([cat_id],[c_id],[c_name],[c_password],[c_state],[c_province],[c_city],[c_addr],[c_corporation],[c_fund],[c_brand],[c_year],[c_month],[c_type],[c_product],[c_contacter],[c_phone],[c_fax],[c_postcode],[c_email],[c_web],[c_desc],[c_date],[checked],[c_company],[c_logo],[c_pic],[c_maillist],[c_bgphoto],[c_menu],[company_code],[en_name],[tax_no],[en_address],[cn_fa_ren],[en_fa_ren],[fa_ren_sex],[hand_phone],[register],[en_desc],[grade1],[grade2],[grade3],[grade])
VALUES ('1','770',' nfbook','nfbook','CN','北京',NULL,'北京市丰台区',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'南风','13426127900',NULL,'100072','nanfengbook@163.com','http://','各个专业类新书、特价图书批发装备!','2008-4-17 15:52:17','2','北京南风文化发展有限公司',NULL,NULL,'0','bg1s.gif','#1967E7',NULL,NULL,'420106728299322',NULL,'南风','nanfeng','M','13426127900',NULL,NULL,NULL,NULL,NULL,NULL)
INSERT INTO [customer] ([cat_id],[c_id],[c_name],[c_password],[c_state],[c_province],[c_city],[c_addr],[c_corporation],[c_fund],[c_brand],[c_year],[c_month],[c_type],[c_product],[c_contacter],[c_phone],[c_fax],[c_postcode],[c_email],[c_web],[c_desc],[c_date],[checked],[c_company],[c_logo],[c_pic],[c_maillist],[c_bgphoto],[c_menu],[company_code],[en_name],[tax_no],[en_address],[cn_fa_ren],[en_fa_ren],[fa_ren_sex],[hand_phone],[register],[en_desc],[grade1],[grade2],[grade3],[grade])
VALUES ('1','1057','0519cjn','520891','CN','江苏省溧阳市',NULL,'江苏省溧阳市清溪路56号',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'陈江南','051987802048',NULL,'213357','0519cjn@163.com','http://www.jshuaneng.cn','一般经营项目:装、电气、仪表设备安装调试;金属结构件、空油设备管道安装;凭资质证书承接土建及装饰装潢工程、人员。','2008-7-12 11:22:06','2','江苏华能建设工程集团有限公司',NULL,NULL,'0','bg1s.gif','#1967E7',NULL,NULL,'3204812101312','jiangsusheng liyangshi qingxilu 56hao','宋小华','SONG XIAO HUA','M','15851915051',NULL,'(wu)',NULL,NULL,NULL,NULL)
INSERT INTO [customer] ([cat_id],[c_id],[c_name],[c_password],[c_state],[c_province],[c_city],[c_addr],[c_corporation],[c_fund],[c_brand],[c_year],[c_month],[c_type],[c_product],[c_contacter],[c_phone],[c_fax],[c_postcode],[c_email],[c_web],[c_desc],[c_date],[checked],[c_company],[c_logo],[c_pic],[c_maillist],[c_bgphoto],[c_menu],[company_code],[en_name],[tax_no],[en_address],[cn_fa_ren],[en_fa_ren],[fa_ren_sex],[hand_phone],[register],[en_desc],[grade1],[grade2],[grade3],[grade])
VALUES ('1','649','07cdzb','0707cdzb','CN','重庆',NULL,'重庆市高新区科园二路137号申基索菲特A座24楼',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'中兵','68159447',NULL,'400050','07cdzb@vip.sina.com','http://','钢材','2008-3-29 11:47:52','2','成都中兵贸易有限公司重庆分公司',NULL,NULL,'0','bg1s.gif','#1967E7',NULL,NULL,'500107747498206',NULL,'廖代君','Liao daijun','M',NULL,NULL,NULL,NULL,NULL,NULL,NULL)
INSERT INTO [customer] ([cat_id],[c_id],[c_name],[c_password],[c_state],[c_province],[c_city],[c_addr],[c_corporation],[c_fund],[c_brand],[c_year],[c_month],[c_type],[c_product],[c_contacter],[c_phone],[c_fax],[c_postcode],[c_email],[c_web],[c_desc],[c_date],[checked],[c_company],[c_logo],[c_pic],[c_maillist],[c_bgphoto],[c_menu],[company_code],[en_name],[tax_no],[en_address],[cn_fa_ren],[en_fa_ren],[fa_ren_sex],[hand_phone],[register],[en_desc],[grade1],[grade2],[grade3],[grade])
VALUES ('1','1039','170779845','598633159','CN','江苏省宜兴市',NULL,'江苏省宜兴市万石工业园区',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'余国强','0510-87816586',NULL,'214212','ygq-005@163.com','www.Jcoc.cn','环保工程的施工、安装统、商品和技术除外)','2008-7-9 10:42:27','2','江苏金山环保工程集团有限公司',NULL,NULL,'0','bg1s.gif','#1967E7',NULL,NULL,'320282752749217',NULL,'钱盘生','Qian pan sheng','M','13961580653',NULL,NULL,NULL,NULL,NULL,NULL)
INSERT INTO [customer] ([cat_id],[c_id],[c_name],[c_password],[c_state],[c_province],[c_city],[c_addr],[c_corporation],[c_fund],[c_brand],[c_year],[c_month],[c_type],[c_product],[c_contacter],[c_phone],[c_fax],[c_postcode],[c_email],[c_web],[c_desc],[c_date],[checked],[c_company],[c_logo],[c_pic],[c_maillist],[c_bgphoto],[c_menu],[company_code],[en_name],[tax_no],[en_address],[cn_fa_ren],[en_fa_ren],[fa_ren_sex],[hand_phone],[register],[en_desc],[grade1],[grade2],[grade3],[grade])
VALUES ('1','1242','215648320','119119','CN','江苏',NULL,'盐城市响水县县城长江路126号',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'张家国','0515-86699110',NULL,'224600','zhangjiaguo5211@163.com','http://','五金,船舶配件','2008-8-17 16:02:44','2','响水县宏洲贸易有限公司',NULL,NULL,'0','bg1s.gif','#1967E7',NULL,NULL,'32092119821018',NULL,'张家国','jiaguozhang','M','13505109857',NULL,NULL,NULL,NULL,NULL,NULL)
--这样呢?如果不行请楼主给出测试数据
select 'cat_id','c_contacter' from customer
union
select top 10 ltrim(cat_id),c_contacter from customer
select 'cat_id','c_contacter' from customer
union all
select top 10 ltrim(cat_id),c_contacter from customer order by newid()
select 'cat_id','c_contacter' from customer
union all
select top 10 ltrim(cat_id),c_contacter from customer
select cat_id,c_contacter from customer
union
select top 10 convert(varchar,cat_id) as cat_id,convert(varchar,c_contacter) as c_contacter from customer
--以网格显示可以用这样的方式
select cat_id,c_contacter from customer
union
select top 10 cat_id,c_contacter from customer
--以文本显示,可以是LZ所说结果