SQL Return code from Select count(*)

What is the return code from SQL if you execute a SELECT COUNT(*) from ... and a count of 0 is returned? Is it 0 or 100开发者_开发技巧 (not found)?

Thank you.

It will always return 1 row with 1 column (containing the number of rows i.e. the count(*) value), if that is what you are asking....

Assuming you are talking about MS SQL Server, the @@error code will always be 0 assuming you query a valid table. The @@error code is describing the success of the action itself, not the success of the results.

Zero because there were no rows. What would 100 have to do with it?

Please look at my answer here too: Does COUNT(*) always return a result?

Edit: unless you mean DB2 as noted elsewhere...