Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Searching Synonyms

Author  Topic 

MarcelF6
Starting Member

1 Post

Posted - 2012-03-17 : 10:23:10
Hi Team

In the added file (it's a table), I search with sqlite3 synonyms for the word 'Ende'. (for example).
I tried it with:

Select 'Ende' from words, con_rel where text = * and con_rel.rel_from = synset;

But with that request, i receive x-times the word 'Ende', but I'd like to receive the synonyms (also with the id's, if that's possible).
How should my request look like?

Thanks for any help/information :)
Marcel

The table is here:
http://www.megafileupload.com/en/file/345148/synsets-db.html

slimt_slimt
Aged Yak Warrior

746 Posts

Posted - 2012-03-18 : 06:50:33
hi Marcel,

Are you using SQL server MSDB?
Can you please post DDL of your table.
the word "Ende" is stored in which column that you want to search?

Or do you want to search the synonyms as a SQL objects one can create?

thanks for your answer.
Go to Top of Page
   

- Advertisement -