I have to make the width of the columns of the table must allow for the maximum number of digits (10 billion) as well as for a negative, and I have no idea how to go about that.
I think you don't talk about 10 billion digits, but 11. So there are several choices of field types. Bigint, money, numeric, double, float. In the latter types you can specify an overall width and precision.
What do you store in that value range? Integer data?
In conjunction with what client side frontend software do you use SQL Server?
What is your problem with the choice of the data type?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.