Wednesday, March 28, 2012

Query problem

I am using SQL SERVER 2005 FT-enable database,
repleat same query it returns the results are expect,but try five times later,
it returns record is no data,
Has anyone seen this issue ?
THANKS!!
It is difficult to understand your question.
It would help us better assist you if you could include table DDL, query
strategy used so far, sample data in the form of INSERT statements, and an
illustration of the desired results. (For help with that refer to:
http://www.aspfaq.com/5006 and to
http://classicasp.aspfaq.com/general/how-do-i-make-sure-my-asp-question-gets-answered.html )
The less 'set up' work we have to do, the more likely you are going to have
folks tackle your problem and help you. Without this effort from you, we are
just playing guessing games.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"akira-888" <akira888@.discussions.microsoft.com> wrote in message
news:E8DEDB72-A958-455A-8458-85FF94B0B7AD@.microsoft.com...
>I am using SQL SERVER 2005 FT-enable database,
> repleat same query it returns the results are expect,but try five times
> later,
> it returns record is no data,
> Has anyone seen this issue ?
> THANKS!!
>
|||Sorry my poor english
my qruestion is
some query like :
select * from test where contains(description ,'二次金改')
return 343 records--ok
try again same query
return 343 records--ok
but try 4 times later the same query,
return 0 record --stranger
and continue try is alway return 0 recode
Next day try the same query ,
return return 343 records--ok
but same situation appear again-try 4 times later the same query
return 0 record
"Arnie Rowland" wrote:

> It is difficult to understand your question.
> It would help us better assist you if you could include table DDL, query
> strategy used so far, sample data in the form of INSERT statements, and an
> illustration of the desired results. (For help with that refer to:
> http://www.aspfaq.com/5006 and to
> http://classicasp.aspfaq.com/general/how-do-i-make-sure-my-asp-question-gets-answered.html )
>
> The less 'set up' work we have to do, the more likely you are going to have
> folks tackle your problem and help you. Without this effort from you, we are
> just playing guessing games.
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to the
> top yourself.
> - H. Norman Schwarzkopf
>
> "akira-888" <akira888@.discussions.microsoft.com> wrote in message
> news:E8DEDB72-A958-455A-8458-85FF94B0B7AD@.microsoft.com...
>
>

No comments:

Post a Comment