sqlserver中全文检索与csw(测试版)实现分词查询测试

 准备工作
一、将数据
1,2020,1,海口君澜商贸有限公司                                                                                ,海南省海口市机场路群芳花园４号                                                                      ,089866734896                                                                                       
2,2020,2,海口多达工贸有限公司                                                                                ,海南省海口市凤翔东路海南省电石厂３幢３０３室                                                        ,013322088106                                                                                       
3,2020,3,洋浦权陈土建安装有限公司                                                                            ,海南省洋浦经济开发区洋浦港商住小区２０２Ｅ房                                                        ,013907656161                                                                                       
4,2020,4,海口共创装饰工程有限公司                                                                            ,海南省海口市和平北路新桥大厦底层２号铺面                                                            ,089868531315                                                                                       
5,2020,5,澄迈金黄牛果菜运销有限公司                                                                          ,海南省澄迈县福山镇立新路３号                                                                        ,013322060448                                                                                       
6,2020,6,北京中理通商标事务所有限公司海口分公司                                                              ,海南省海口市坡博路化工总公司住宅小区临街铺面                                                        ,089866268073                                                                                       
7,2020,7,中铁快运有限公司海口第一营业部                                                                      ,海南省海口市海府路１１１号一楼Ａ栋、第６、７间铺面                                                  ,089865220237                                                                                       
8,2020,8,兰州宏业防火门有限责任公司海南分公司                                                                ,海南省海口市南沙路５９号瑞丰公寓Ａ座１５０５室                                                      ,013907558196                                                                                       
9,2020,9,三亚市崖州民歌协会                                                                                  ,海南省三亚市新好景大酒店                                                                            ,013627508580                                                                                       
10,2020,10,海口康舒达健康咨询有限公司                                                                          ,海南省海口市国贸路１６号金福城Ｃ－２３１－Ａ房                                                      ,013005001860                                                                                       
11,2020,11,海口蜘蛛计算机网络服务有限公司                                                                      ,海南省海口市大同路１１号１栋５０２房                                                                ,089868168658                                                                                       
12,2020,12,海南诚信地产发展有限公司                                                                            ,海南省海口市机场东路３０号天福新村１－５０１室                                                      ,089866781907                                                                                       
13,2020,13,五指山阿陀岭旅游开发有限责任公司                                                                    ,海南省五指山市农林路旅游宾馆                                                                        ,089886639219                                                                                       
14,2020,14,保亭林峰农林业技术开发有限公司                                                                      ,海南省保亭黎族苗族自治县红毛丹街粮食局住宿楼４幢首层                                                ,013307551785                                                                                       
15,2020,15,海口婴之初婴幼儿智力开发咨询有限公司                                                                ,海南省海口市国贸路ＣＭＥＣ大厦二楼中区                                                              ,013876820100                                                                                       
16,2020,16,三亚诚海石油销售有限责任公司                                                                        ,海南省三亚市南岛农场                                                                                ,013086063688                                                                                       
17,2020,17,海口华尔居装饰工程有限公司                                                                          ,海南省海口市国贸路国联大厦Ａ座６０１房                                                              ,013078989488                                                                                       
18,2020,18,三亚天一物业管理有限公司                                                                            ,海南省三亚市凤凰镇海坡开发区                                                                        ,089988330668

存为t_list.txt,并将t_list.txt存在e根目录下
二、在sqlserver端执行建表语句
CREATE TABLE [dbo].[T_List](
 [id] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
 [T_Listindexno] [decimal](18, 0) NULL,
 [T_Listno] [decimal](18, 0) NULL,
 [T_ListEPname] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL,
 [T_ListEPAdress] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL,
 [T_ListEPPhone] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL,
 CONSTRAINT [PK_T_List] PRIMARY KEY CLUSTERED
(
 [id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
三、sqlserver执行
EXEC master..xp_cmdshell 'bcp test.dbo.T_List in e:/t_list.txt -c -q  -U "sa" -P "pwd" -t","' 将数据导入表中
四、--添加全文索引
exec sp_fulltext_database 'enable'
execute sp_fulltext_catalog 'ft_titles', '