February 25, 2004 at 3:47 pm
I saw something strange today. I run a query "Select * from table where date ='1/1/04' ", it returns 400 rows, but when i change the query to Select count(*) from table where date ='1/1/04' ", it returns 0. What do I need to update to fix this problem.
Thanks for the help.
February 25, 2004 at 9:24 pm
Select count(1) from table where date = '01/01/2004'
February 25, 2004 at 9:32 pm
I tried that , it returns zero.I recreated the Index and it fixed the problem.
February 25, 2004 at 9:38 pm
It is strange
What is the relation with the index
My Blog:
February 26, 2004 at 12:04 am
sql2k with sp3a on a multiprocessor box ? There is an issue with count(*). Hotfix is available at MS.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 27, 2004 at 6:47 am
Very strange. I assume that the column 'date' not this defined like so. But the probable thing is that it has an error in the definition of the value for which these applying the sentence.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply