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.
| Author |
Topic |
|
bilencekic
Posting Yak Master
121 Posts |
 Posted - 2007-02-21 : 14:53:23
|
| hey,i have a forum databasemy friend says that full text catalog holds the words that inserted to database and how many of them exists in database.is that true ?i dont believe this.cant be true .welli need a word count in my database and which have the max exist number.i dont have the world list.how can i get the word which existed max on my database ?according to me , it is imposibble.if you dont have the word list.and it will take ages to count a word that how many it existed on the table . (counting the word on string and on 10.0000 messages)MS BLESS US |
|
|
GazNewt
Starting Member
14 Posts |
Posted - 2007-02-21 : 17:31:35
|
| Yes it is definitely possible. This is how google can so quickly locate web pages containing your search phrase.There will be table called tags, for example :id tag-- ---1 my2 first3 entryand a table which links these tag records to the forum post called forumentry_tags, for example :id forumentryid tagid nexttagid-- ------------ ----- ---------1 1002 1 22 1002 2 33 1002 3 NULLThese would be the entries for forum post id 1002, which is "my first entry". For longer posts there would be more records.You need to locate the equivalent of the forumentry_tags table and do a select like this :select top 1 count(tagid) from forumentry_tags group by tagidsomething like that anyway... |
 |
|
|
|
|
|
help on full text and some other things!!!!