SELECT * FROM table_name WHERE CONTAINS(fulltext_column, 'search_condition')
SELECT student_id, student_name
FROM students
WHERE CONTAINS(address, 'beijing')
SELECT student_id, student_name
FROM students
WHERE CONTAINS(address, '"hebei province"')
WHERE CONTAINS(address, '"hebei province" OR beijing')
WHERE CONTAINS(address, 'nanjing NEAR road')
匹配 "nanjing road"、"nanjing east road"、"nanjing west road" 等,表示兩詞距離較近。
WHERE CONTAINS(address, '"hu*"')
匹配 "hubei"、"hunan" 等以 "hu" 開頭的詞。注意:全文索引使用 * 而非 %。
WHERE CONTAINS(address, 'ISABOUT (city WEIGHT(.8), county WEIGHT(.4))')
指定各條件權重 (0.0-1.0),影響 RANK 分數計算,適用於 CONTAINSTABLE 排序。
WHERE CONTAINS(address, 'FORMSOF (INFLECTIONAL, street)')
匹配 "street"、"streets" 等變體;動詞會匹配不同時態 (dry/dried/drying)。
CHANGE_TRACKING AUTO 後,資料異動近乎即時反映於全文索引,不再如舊版需手動填入。範例使用英文係因中文斷詞器需額外安裝 (SQL 2000 需安裝中文斷詞器),且部份語法 (如 NEAR、ISABOUT) 在中文環境下行為可能不同。建議實測驗證。