Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

COUNT command rejected in SQL Query

  
   Database Forums (Home) -> MSEQ RSS
Next:  full-text index with multiple tables  
Author Message
Parrot

External


Since: Sep 04, 2007
Posts: 12



(Msg. 1) Posted: Tue Jun 03, 2008 5:41 pm
Post subject: COUNT command rejected in SQL Query
Archived from groups: microsoft>public>sqlserver>mseq (more info?)
My C# Windows program does not recognize the COUNT command in a SQL query
string using SQL Server 2005. I can use the command when I code the query
manually against the data base. It rejects the command SELECT COUNT(*) FROM
EARNDED. Does anyone know how to get around this problem?
Dave

 >> Stay informed about: COUNT command rejected in SQL Query 
Back to top
Login to vote
Parrot

External


Since: Sep 04, 2007
Posts: 12



(Msg. 2) Posted: Tue Jun 03, 2008 7:03 pm
Post subject: RE: COUNT command rejected in SQL Query [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
I forgot to mention that I have this problem only on my computer with the
VISTA system whereas it works ok on the computer with XP. Why would an
operating system make a difference. Also, I used SQLEXPRESS on the XP while
I use the SQL SERVER 2005 on VISTA.
Dave

"Parrot" wrote:

> My C# Windows program does not recognize the COUNT command in a SQL query
> string using SQL Server 2005. I can use the command when I code the query
> manually against the data base. It rejects the command SELECT COUNT(*) FROM
> EARNDED. Does anyone know how to get around this problem?
> Dave

 >> Stay informed about: COUNT command rejected in SQL Query 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
query - Hi, I have some models that have hyhen in between. e.g.1200LD-VCD, abc-1234 May I know how to remove the hyhen. Thank you

query - hi i have some models that end with +SP e.g. 1234+SP, abcd+SP I want to remove only the +SP from these models. May i know how can i do it. Thank you

SQL Query - Hi all, i am not able to make up a query according to my need. can anyone help. Following is my simple query. select udf_name [Severity],st_name [Status], count(2) [count] from bugs, statuses, user_defined_attribute where udf_id =..

SQL Query - Dear all, i've one table (A) which has one field with uniqure phone number recrods, and there is another table (B) which includes misc. numbers plus records from table A. my query is that i want to knwo that which number from table A and how many ..

Query needs to loop? - Is this possible? A char variable length field contains this data: (for example) ABC,XYZ,GEF,CAB I need to query another table on the contents of each of these names that are separated by comma. I need to read ABC and then query another table for ABC in...
   Database Forums (Home) -> MSEQ All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]