Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
SET FIXED Command
Collapse the table of content
Expand the table of content

SET FIXED Command

Visual Studio .NET 2003

Specifies if the number of decimal places used in the display of numeric data is fixed.

SET FIXED ON | OFF

Parameters

ON
Uses the SET DECIMALS setting to determine the number of decimal places displayed in results. The default number of decimal places is 2.
OFF
(Default) Allows the number of decimal places displayed in results to depend on the specific constants, variables, and operators used in a numeric expression. The contents of fields are displayed with the declared number of decimal places.

Remarks

SET FIXED is scoped to the current data session.

See Also

SET DECIMALS | SET DATASESSION | Numeric Data Type

Show:
© 2015 Microsoft