数字的最大长度 [英] Maximum length for numeric

问题描述

嗨...
我在表中给出了一个字段，其数据类型为numeric(8,2).现在，我想知道应允许在该字段中输入多少个值，请稍后指导....

Hi...
I gave a field with the datatype of numeric(8,2) in my table. Now i want to know how many values should be allowed to enter into that field,guide me soon....

推荐答案

有关精度，小数位数和长度，请参阅MSDN页面SQL数据类型: http://msdn.microsoft.com/en-us/library/ms190476.aspx [ ^ ]

Refer MSDN page for precision, scale and length of SQL data types: http://msdn.microsoft.com/en-us/library/ms190476.aspx[^]

数字(p，s)
其中p是精度值； s是小数位数值.

例如，numeric(6,2)是一个数字，该数字在小数点前有4位数字，在小数点后有2位数字.

numeric(p,s)
Where p is a precision value; s is a scale value.

For example, numeric(6,2) is a number that has 4 digits before the decimal and 2 digits after the decimal.

Hi，

请参阅
http://msdn.microsoft.com/en-us/library/aa258271％28v = sql.80％29.aspx [ ^ ]

Hi,

Refer to
http://msdn.microsoft.com/en-us/library/aa258271%28v=sql.80%29.aspx[^]

这篇关于数字的最大长度的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！