Full-Text Search and Semantic Search Functions (Transact-SQL)
Applies to: SQL Server
This section describes the system functions related to full-text search and semantic search.
Full-Text Search Functions
CONTAINSTABLE (Transact-SQL)
Returns a table of zero, one, or more rows for those columns containing precise or fuzzy (less precise) matches for single words and phrases, the proximity of words within a certain distance of one another, or weighted matches.
FREETEXTTABLE (Transact-SQL)
Returns a table of zero, one, or more rows for those columns containing values that match the meaning, and not just the exact wording, of the text in the specified freetext_string.
Semantic Search Functions
semantickeyphrasetable (Transact-SQL)
Returns a table with zero, one, or more rows for those key phrases associated with columns in the specified table.
semanticsimilaritydetailstable (Transact-SQL)
Returns a table of zero, one, or more rows of key phrases common across two documents (a source document and a matched document) whose content is semantically similar.
semanticsimilaritytable (Transact-SQL)
Returns a table of zero, one, or more rows for those columns whose content is semantically similar to a specified document.
Geri Bildirim
https://aka.ms/ContentUserFeedback.
Çok yakında: 2024 boyunca, içerik için geri bildirim mekanizması olarak GitHub Sorunları’nı kullanımdan kaldıracak ve yeni bir geri bildirim sistemiyle değiştireceğiz. Daha fazla bilgi için bkz.Gönderin ve geri bildirimi görüntüleyin