Article ID: 274353 - View products that this article applies to.
This article was previously published under Q274353
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 58065 (SQLBUG_70)
When you use the Microsoft SQL Server 7.0 Query Analyzer client tool with a smallint data type and a COMPUTE clause, unexpected results may be returned for the computed summary result. This behavior occurs only with negative numbers between -10000 and
To work around this problem, use either of the following:
Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
274799For more information, contact your primary support provider.
(http://support.microsoft.com/kb/274799/ )INF: How to Obtain Service Pack 3 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0
Steps to Reproduce BehaviorRun this code:
When you use OSQL to run the same query, this is the result:
my_int ------ -10000 10000 min ===== (unexpected result) (3 row(s) affected)
my_int ------ -10000 10000 min ====== -10000