【SQL开源代码栏目提醒】:网学会员在SQL开源代码频道为大家收集整理了CH14.sql提供大家参考,希望对大家有所帮助!
-- P14-3
USE 练习01;
GO
sp_fulltext_database 'enable';
GO
-- P14-17a
SELECT *
FROM 客户
WHERE CONTAINS (地址, '师大路')
-- P14-17b
SELECT *
FROM 客户
WHERE CONTAINS (地址, ' "Parkway Fremont" ')
-- P14-17c
SELECT *
FROM 客户
WHERE CONTAINS (地址, ' "Parkway Fremont"
OR "路"
OR "东路" ')
-- P14-18a
SELECT *
FROM 客户
WHERE CONTAINS (地址, ' "Pa*" ')
-- P14-18b
SELECT *
FROM 客户
WHERE CONTAINS (地址, ' "CA" NEAR "USA" ')
-- P14-18c
SELECT *
FROM 客户
WHERE CONTAINS (客户名称, 'FORMSOF (INFLECTIONAL, flag)' )
-- P14-20a
SELECT *
FROM 客户
WHERE CONTAINS (地址,
'ISABOUT ( USA weight (0.8),
重庆南路 weight (0.5),
师大路 weight (0.1) )'
)
-- P14-20b
SELECT *
FROM 客户
WHERE FREETEXT (*, ' Fremont CA USA ')
-- P14-22a
SELECT 客户编号, 地址, My_Table.*
FROM 客户
INNER JOIN
CONTAINSTABLE (客户, 地址, ' 罗斯福 OR 一段 OR USA ' )
AS My_Table
ON 客户编号 = My_Table.[KEY]
ORDER BY My_Table.RANK DESC
-- P14-22b
SELECT 地址, My_Table.RANK
FROM 客户
INNER JOIN
CONTAINSTABLE (客户, 地址, ' ISABOUT ( 南京 WEIGHT(0.1),
一段 WEIGHT(0.4), 忠孝 WEIGHT(0.7) )', 3 )
AS My_Table
ON 客户编号 = My_Table.[KEY]
-- P14-23
SELECT 地址, My_Table.*
FROM 客户
INNER JOIN FREETEXTTABLE (客户, 地址, '忠孝 中山 南京')
AS My_Table
ON 客户编号 = My_Table.[KEY]
ORDER BY My_Table.RANK DESC
-- P14-26a
SELECT 编号, , 性别
FROM 应征者
WHERE CONTAINS (自传, '
xml' )
-- P14-26b
SELECT 编号, , 性别
FROM 应征者
WHERE CONTAINS (自传, ' "SQL Server" OR
HTML' )