What datatypes could be given to this value --> 45.58
Could these be given:
What's the difference then? Which one would be the best to use?
migrated from stackoverflow.com Feb 13 '12 at 22:03
This question came from our site for professional and enthusiast programmers.
Like everything else in SQL Server, it depends.
So, what do you want to use the field for? What does your data actually represent? That should be the determining factor in what datatype you use.
I don't believe that any particular format is somehow more better than another: it depends on your needs and the tradeoffs inherent in all of these (decimal/numeric, for instance, chew up a relatively lot of space). There's nothing to stop you from rolling your own, either: you could, for instance, store your