Explain Full-Text Query in SQL Server

Explain Full-Text Query in SQL Server

Full-Text Query search allows to search for the entire text instead of using “%” . it is most commonly used to search for text whose data type is TEXT or NOTE. Some predicates like FREETEXT, CONTAINS are used in full text query search.

FREETEXT finds the word or words you give it anywhere in the search column.


SELECT Apparel FROM Products WHERE FREETEXT (Apparel, 'Van' )

The query above will return results like
Best Van Huesen trousers

Explain Full-Text Query in SQL Server.

SQL Server supports searches on character string columns using Full-Text Query. This query uses full-text catalogs and indexes to perform activities which are managed by the Microsoft search service. The full-text catalogs and indexes are not stored in a SQL Server database and they can't be backed up and restored by using the Transact-SQL BACKUP and RESTORE statements. The full-text catalogs must be resynchronized separately after a recovery or restore operation.
Phases a transaction has to undergo
The several phases a transaction has to go through are listed here. Database is in a consistent state when the transaction is about to start.......
SQL server XPath - What is XPath?
SQL server XPath - XPath is a language defined by the W3C, used to select nodes from XML documents. SQL Server 2000 supports .....
Define the rules for designing Files and File groups in SQL Server.
SQL Server Files and File groups - A file or file group can only be used by one database. For example, the files abc.mdf and abc.ndf contains......
Post your comment