你当前正在访问 Microsoft Azure Global Edition 技术文档网站。 如果需要访问由世纪互联运营的 Microsoft Azure 中国技术文档网站,请访问 https://docs.azure.cn。
The decimal data type
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel
The decimal
data type represents a 128-bit wide, decimal number.
Caution
Arithmetic operations involving decimal
values are significantly slower than operations on real data type.
If your use case doesn't require very high precision, we recommend using real
.
decimal
literals
To specify a decimal
literal, use one of the following syntax options:
Syntax | Description | Example |
---|---|---|
decimal( number) |
A decimal number represented by one or more digits, followed by a decimal point, and then one or more digits. | decimal(1.0) |
decimal( numbere exponent) |
A decimal number represented by scientific notation. | decimal(1e5) is equivalent to 100,000 |
decimal(null) |
Represents the null value. |
Learn more about syntax conventions.