On Transact SQL language the decimal is the same like numeric data types and have fixed precision and scale.
Decimal syntax:
| Precision | Storage |
|---|---|
| 1 - 9 | 5 Bytes |
| 10-19 | 9 Bytes |
| 20-28 | 13 Bytes |
| 29-38 | 17 Bytes |
Decimal example:
USE model;
GO
CREATE TABLE myDecTable ( b decimal (7,2) );
GO
INSERT INTO myDecTable VALUES (234);
GO
SELECT b FROM myDecTable;
GO
| Results |
|---|
| 234.00 |