• no. '1000' is precision 4. so you can have numeric(4,0). ie 4 decimal values in the left of decimal point and not numeric(1000,7)

    Ref: http://msdn.microsoft.com/en-us/library/ms187746.aspx

    You can understand what is numeric data type and what is precision and scale number