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
Subscribe to:
Post Comments (Atom)
Data transformation services,sql server
No comments:
Post a Comment