asked
Table column will have only whole numbers.
Numbers throughout the table may range from zero to three billion 1) small int 2) big int 3) int 4) bit 5) real
You should keep your datatypes as small as possible, yet big enough to fit the data you intend to store. The maximum value of an int is 2147483647 (2.147... billion). So if you intend to store values larger than that, you need a bigint column. No need for float or real if you don't intend to store decimal values. Is this a homework assignment?
15 People are following this question.
