Numeric - TSQL Tutorial

On Transact SQL language the numeric data types that have fixed precision and scale.

Numeric syntax:

PrecisionStorage
1 - 95 Bytes
10-199 Bytes
20-2813 Bytes
29-3817 Bytes

Numeric example:

USE model;
GO
CREATE TABLE myNumTable ( a numeric (12,6) );
GO
INSERT INTO myNumTable VALUES (777.123);
GO
SELECT a FROM myNumTable;
GO

Results
777.123000