Member
164
Points
|
Replied on
13 Aug 2013 10:43 PM IST
Full-Text Search in SQL Server lets users and applications run full-text queries against character-based data in SQL Server tables. - Before you can run full-text queries on a table, the database administrator must create a full-text index on the table.
- The full-text index includes one or more character-based columns in the table. These columns can have any of the following data types: char, varchar, nchar, nvarchar, text, ntext, image, xml, or varbinary(max) and FILESTREAM.
- Each full-text index indexes one or more columns from the table, and each column can use a specific language.
Full-text queries perform linguistic searches against text data in full-text indexes by operating on words and phrases based on rules of a particular language such as English or Japanese.
Full-text queries can include simple words and phrases or multiple forms of a word or phrase. A full-text query returns any documents that contain at least one match (also known as a hit). A match occurs when a target document contains all the terms specified in the full-text query, and meets any other search conditions, such as the distance between the matching terms.
|