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
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