Microsoft KB Archive/268594

= PRB: Inconsistency in Behavior Between CREATE STATISTICS and UPDATE STATISTICS =

Article ID: 268594

Article Last Modified on 11/5/2000

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q268594



SYMPTOMS
CREATE STATISTICS allows the value of 'N' in 'SAMPLE N PERCENT' to be a non-integer value; however, UPDATE STATISTICS does not. If you use a non-integer value in UPDATE STATISTICS, the following error message occurs:

Server: Msg 170, Level 15, State 1, Line 2

Line 2: Incorrect syntax near 'non-integer value'.



WORKAROUND
Here are two ways to work around this problem:
 * Use an integer value to update the statistics.

-or-


 * Drop and re-create the statistics.



MORE INFORMATION
This behavior is by design.

Additional query words: fractional part update statistics create

Keywords: kbprb KB268594

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.