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

Numeric syntax:

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