T-SQL Tutorial

Decimal - TSQL Tutorial


On Transact SQL language the decimal is the same like numeric data types and have fixed precision and scale.

Decimal syntax:

PrecisionStorage
1 - 95 Bytes
10-199 Bytes
20-2813 Bytes
29-3817 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