• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 235
  • Last Modified:

how do I generate keywords from a nvarchar field in a mssql 2005 database?

I need to generate keywords from a large nvarchar(max) field in a database. Does anyone know of any algorithms for doing this? or is there a way to do it with full text indexing? the database is mssql 2005.
0
jbrahy
Asked:
jbrahy
  • 3
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
Hello jbrahy,

Keywords ? can you give an example ?



Aneesh R
0
 
jbrahyAuthor Commented:
ok, let's take the text of your comment:

Hello jbrahy,

Keywords ? can you give an example ?

Aneesh R

the keywords in that would be hello, jbrahy, keywords, example and aneesh. I don' think any of the other words would be considered keywords or helpful in search results.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
are you aware the the full-text indexing of sql server does "exactly" that?
well, the question is actually what you want to do with that list, in the end?
0
 
jbrahyAuthor Commented:
I've never used full text indexing so I wasn't aware of that. the end result of what I want is to link product descriptions with article keywords so I need to have two sets of keywords and return the best matching results.

Could you point me to an example of something like that?
0
 
jbrahyAuthor Commented:
so another question with no answer....
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now