Error?

[SQLnewcommer]

Hello,
I am creating a data warehouse using T-SQL.
I am getting the following error:

[Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error

Any idea about how to solve it?

 

[SimonSellick]

It's quite easy:

- find the statement that generates the error;
- investigate what it is doing that isn't allowed;
- fix it.

If you give us some clues (when it happens, what you are running, source code), someone might be able to help!

 

[SQLDenis]

you need parentheses around the field
select count(field) from table

“I sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --

http://sqlservercode.blogspot.com/