Whats the difference between int,float and decimal in sql server.
WHich data type takes how many bytes?
What data type i should use to store the following sets of data
1set--100000,854275,74892734
2set--6538726.98765923,762.659325
Thanks.int is for integers. 4-byte. Max value is 2^31. This looks adequate for your first set although if the numbers will exceed 2^31 you should use bigint (8 bytes)
float is for floating point numbers (non-integers). You will need floating point for the second set. I would suggest the double type for that set.
decimal, numeric, and float all support customizable precision levels. BOL has pretty good documentation on this.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment