Exact Numeric Datatypes

Use the exact numeric datatypes to represent a value exactly. SAP ASE provides exact numeric types for both integers (whole numbers) and numbers with a decimal portion.

Transact-SQL provides the smallint, int, bigint, numeric, and decimal ANSI SQL exact numeric datatypes. The unsigned bigint, unsigned int, unsigned smallint, and tinyint types are Transact-SQL extensions.

• Integer Types
  SAP ASE provides these exact numeric datatypes to store integers: bigint, int (or integer), smallint, tinyint and each of their unsigned counterparts. Choose the integer type based on the expected size of the numbers to be stored. Internal storage size varies by type:
• Decimal Datatypes
  SAP ASE provides two other exact numeric datatypes, numeric and dec[imal], for numbers that include decimal points. The numeric and decimal datatypes are identical in all respects but one: only numeric datatypes with a scale of 0 and integer datatypes can be used for the IDENTITY column.