Monday, April 12, 2010 12:59 PM
how to use Full-Text Search to search in an HTML Formatted Text
is there any links
is it complex task or it just need some settings?
- Moved by Alex Feng (SQL)Moderator Wednesday, April 14, 2010 3:20 AM move to an appropriate forum (From:SQL Server Database Engine)
Monday, April 12, 2010 1:23 PM
Should have asked in Full Text Search forum.
You can store your HTML as varbinary(MAX) column and documnet type as .html or .htm
but in my opinion some of the html tags need to be omitted as noise words like </br> or </p>
- Edited by Chirag Shah Monday, April 12, 2010 2:24 PM content
Tuesday, April 13, 2010 11:49 AM
thanks alot for your reply.
is it a way to know which tags full text search will omit
and which ones i have to Add as noise words
- Edited by A.Salah Tuesday, April 13, 2010 11:51 AM the word add peared as aline
Wednesday, April 14, 2010 10:38 AMfull text search will not index html tags if you use the document type extension for html.
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941