# SQL Server Rule: SRD0027
| | |
|----|----|
| Assembly | SqlServer.Rules |
| Namespace | SqlServer.Rules.Design |
| Class | NoPrecisionScaleRule |
## Rule Information
| | |
|----|----|
| Id | SRD0027 |
| Friendly Name | Unspecified precision or scale |
| Category | Design |
| Ignorable | false |
| Applicable Types | Procedure |
| | Scalar Function |
| | Table |
| | Table Valued Function |
## Description
Do not use DECIMAL or NUMERIC data types without specifying precision and scale.
## Summary
Do not use DECIMAL or NUMERIC data types without specifying precision and scale.
### Remarks
The rule checks the T-SQL code for use <c>DECIMAL</c> or <c>NUMERIC</c> data types without
specifying length. Avoid defining columns, variables, and parameters using
<c>DECIMAL</c> or <c>NUMERIC</c> data types without specifying precision, and scale. If no
precision and scale are provided, SQL Server will use its default size <c>NUMERIC(18, 0)</c>.
<sub><sup>Generated by a tool</sup></sub>
