>La precisione minima del tipo numeric sembra essere 1 e non 0:
>
>http://msdn.microsoft.com/it-it/library/ms187746.aspx
Infatti la precision in NUMERIC(11,0) è 11 (lo scale è 0) 
DECLARE @n NUMERIC(11, 0) = 12345678901;
SELECT @n AS n;
/* Output:
n
---------------------------------------
12345678901
(1 row(s) affected)
*/
In SQL Server DECIMAL e NUMERIC sono sinonimi, ma lo standard ANSI SQL 2003 (§6.1 Data Types) prevede questa piccola differenza:
<exact numeric type> ::=
NUMERIC [ <left paren> <precision> [ <comma> <scale> ] <right paren> ]
| DECIMAL [ <left paren> <precision> [ <comma> <scale> ] <right paren> ]
| DEC [ <left paren> <precision> [ <comma> <scale> ] <right paren> ]
| SMALLINT
| INTEGER
| INT
| BIGINT
...
21) NUMERIC specifies the data type exact numeric, with the decimal precision and scale specified by the <precision> and <scale>.
22) DECIMAL specifies the data type exact numeric, with the decimal scale specified by the <scale> and the implementation-defined decimal precision equal to or greater than the value of the specified <precision>.
Ciao!
--
Lorenzo Benaglia
Microsoft MVP - SQL Server
http://blogs.dotnethell.it/lorenzo/
http://italy.mvps.org