How can I display a value as 0.00 from a field of datatype numeric?How can I display a value as 0.00 from a field of datatype numeric?
select convert(numeric(9,2),round(columnname,2)) from tablename
Showing posts with label datatype. Show all posts
Showing posts with label datatype. Show all posts
Tuesday, February 14, 2012
Subscribe to:
Posts (Atom)