Suppose you want to add a column to Table 6-4 that contains the price of the product. None of your products cost more than $300. Which data type should you use?
(This new column would be best suited for smallmoney. Int allows only whole numbers so it would not allow change (in other words, $1.50 would not work). Float would work as well, but it is not meant for storing currency. Money is meant for storing currency, but it is best suited to values larger than 214,748.3647. So, because you are selling products valued at less that $300, it is best to use smallmoney.)