You are developing a database that will contain price information.

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. Small money

D. Numeric

Explanation:

Numeric is the only one in the list that can give a fixed precision and scale.

Reference: http://msdn.microsoft.com/en-us/library/ms179882.aspx