Apr 172013
 
Use the DECIMAL data type in SQL Server. Alternatively, you can use NUMERIC.
Both those types take a two-part argument: A precision and a scale. The precision is the total number of digits allowed, including decimal places; the scale is the number of decimal places you will want; in your case, 2.
So, DECIMAL(10,2) or NUMERIC(10,2) would allow any number from 0.00 to 99999999.99.
ALTER TABLE tablename
ALTER COLUMN columnname
DECIMAL(10,2)
UPDATE:
If changing the data type is not an option, the best you can do is round your results in select statements.
SELECT ROUND(column, 2) FROM table