Today I had tried to solved this bug . I have to confess that this take some extra time by me .
The problem is i create a table name color and insert the field into them and execute this query
select * from color
Black
Blue
Green
Red
After inserting some data i run this query for checking any value is available in it or not
SELECT COUNT(1) color
It seems good becuase i write this query very rapidally and do not think about this create a bug?
when i run this it always return 1 . i am afraid WTF in this .
i spend some time on this but not able to get the error. really i think that is SQL Server corrupted or anything else .
after frustrating i go to took a cup of tea .
and when i came i suddenly saw the error there is mistake of from . i am not using from in my query .
SELECT COUNT(1) from color
this is silly but happened with me .
Hope this will help you .
ROHIT KUMAR SRIVASTAVA
The problem is i create a table name color and insert the field into them and execute this query
select * from color
Black
Blue
Green
Red
After inserting some data i run this query for checking any value is available in it or not
SELECT COUNT(1) color
It seems good becuase i write this query very rapidally and do not think about this create a bug?
when i run this it always return 1 . i am afraid WTF in this .
i spend some time on this but not able to get the error. really i think that is SQL Server corrupted or anything else .
after frustrating i go to took a cup of tea .
and when i came i suddenly saw the error there is mistake of from . i am not using from in my query .
SELECT COUNT(1) from color
this is silly but happened with me .
Hope this will help you .
ROHIT KUMAR SRIVASTAVA
No comments:
Post a Comment