In addition to searching textual data stored in text-based columns of a database, iFTS can be used to search documents stored in the database. As with database searches, you need a full-text index for the document you want to search.
Creating a Full-Text Index for Documents
You can create a full-text index for a document using a variation of the CREATE FULLTEXT INDEX statement. A statement that creates a full-text index for the Production. Document table follows:CREATE FULLTEXT INDEX ON Production.Document
This version is very similar to the CREATE FULLTEXT INDEX statement for a database, with one slight difference. In this variation, the varbinary(max) Document column is specified as the column to include in the full-text index. Immediately following the column name is the TYPE COLUMN clause, followed by a column containing the document type. The FileExtension column is specified in this instance. This column contains document types of .doc, which indicates aMicrosoft Word document. The type column is particularly important, since it tells SQL Server which filter should be used to extract indexable information from the document.
You can query the sys.fulltext_document_types catalog view to get a list of all the supported document types and their associated extensions.
The AdventureWorks sample database has a table called Production.Document, which contains Microsoft Word documents in a varbinary(max) column named Document. The AdventureWorks database comes with a full-text index already created on the Document column of the Production.Document table, so we can skip the full-text index creation statement for this example. The following sample FREETEXT query locates documents that have the word safe in them. It returns the two documents shown in Figure.SELECT DocumentNode, Title, DocumentSummary
Results of the full-text document query
SQL Server 2008 Related Interview Questions
|SQL Server 2000 Interview Questions||MSBI Interview Questions|
|SQL Server 2008 Interview Questions||SQL Server 2005 Interview Questions|
|SSIS(SQL Server Integration Services) Interview Questions||SSRS(SQL Server Reporting Services) Interview Questions|
|Microsoft Entity Framework Interview Questions||LINQ Interview Questions|
|SQL Server Analysis Services (SSAS) Interview Questions||Sql Server Dba Interview Questions|
SQL Server 2008 Related Practice Tests
|SQL Server 2000 Practice Tests||MSBI Practice Tests|
|SQL Server 2008 Practice Tests||SQL Server 2005 Practice Tests|
|SSIS(SQL Server Integration Services) Practice Tests||SSRS(SQL Server Reporting Services) Practice Tests|
|Microsoft Entity Framework Practice Tests||LINQ Practice Tests|
Sql Server 2008 Tutorial
Sql Server 2008 Overview
Sql Server Installation And Configuration
Sql Server Encryption
Automation And Monitoring
Integrated Full-text Search
New Datatypes In Sql Server 2008
T-sql Enhancements For Developers
T-sql Enhancements For Dbas
Sql Server And Xml
Sql Server Xml And Xquery Support
Linq To Sql
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.