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 |
|
Borllor Lee
Starting Member
4 Posts |
 Posted - 2008-11-05 : 10:15:12
|
| In the Database, There is table named SmsBook that is 2 million datas,There, I want to find some datas from "nnts" column, Datas format like this: nnts0000070800000708.507.00100000708.22107659000.56107659000..............Then, I want to find words "07" in this column, nnts. If I don't use the fulltext, It is very slowy, though I have create index in this column. When I enabled fulltext for the database and created fulltext in this column of SmsBook table.I find on datas for the key words "07".I don't know how to solve this problem? There is other solution? Thx |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-11-05 : 10:51:10
|
If you always want to search for 07, make a persisted computed column of BIT datatype wether or not the data has 07 in it.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
Borllor Lee
Starting Member
4 Posts |
Posted - 2008-11-05 : 19:39:36
|
| Yeah, I solve it! Thx, I used the format condition like this contains(nnts, '"*07*"') |
|
|
|
Borllor Lee
Starting Member
4 Posts |
Posted - 2008-11-06 : 00:43:15
|
| Oh, It is very strange, In the morning, It is work, now it is not work |
|
|
|
karthickbabu
Posting Yak Master
151 Posts |
Posted - 2008-11-06 : 01:07:18
|
| Full Text is easy to find your requirement. Did u try FullText? What happen when u use FullText.================================================When you realize you've made a mistake, take immediate steps to correct it. |
|
|
|
Borllor Lee
Starting Member
4 Posts |
Posted - 2008-11-06 : 01:57:52
|
quote:
Originally posted by karthickbabu
Full Text is easy to find your requirement. Did u try FullText? What happen when u use FullText.================================================When you realize you've made a mistake, take immediate steps to correct it.
Yes I have tried, but there is no datas when searching key words "07". I hope there are some datas where nnts column contains the key words. Thx |
|
|
|
|
|
|
|
|
How to improve query speed?The FullText can not...