• FullText Search In SqlServer 2005

    why fulltext search used? <span style="font-size:10pt;"><font face="Verdana">Full-text search allows fast and flexible indexing for keyword-based query of text data stored in a SQL Server Database. Unlike the LIKE predicate, which only works on character patterns, full-text queries perform a linguistic search against this data, operating on words and phrases based on rules of a particular…