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 |