Alen Malhasoglu's Blog

Very useful query that uses FullText search is as follows: USE Northwind; GO SELECT KEY_TBL.RANK, FT_TBL.Description FROM Categories AS FT_TBL INNER JOIN FREETEXTTABLE(Categories, Description, ‘How can I make my own beers and ales?’) AS KEY_TBL ON FT_TBL.CategoryID = KEY_TBL.[KEY] ORDER BY KEY_TBL.RANK DESC; GO Here we see a column as “RANK”. This column is used […]