Which data type should you use?

You are developing a database that will contain price information.
You need to store the prices that include a fixed precision and a scale of six digits.
Which data type should you use?

You are developing a database that will contain price information.
You need to store the prices that include a fixed precision and a scale of six digits.
Which data type should you use?

A.
Float

B.
Money

C.
Smallmoney

D.
Decimal

Explanation:
Decimal is the only one in the list that can give a fixed precision and scale. http://msdn.microsoft.com/en-us/library/ms187746.aspx



Leave a Reply 2

Your email address will not be published. Required fields are marked *