In MS Access, for numeric fields, the decimal places shown can be defined as "Auto" meaning that the database will determine the number of decimal places to show based on the content of the field (i.e. 1.0, 0.75, 1.125).
In SQL Server for the same field, it appears that decimal precision is hard coded resulting in a fixed representation (i.e. 1.000, 0.750, 1.125)
Is there a way to make the decimal representation in SQL Server more like Access where trailing zeros are truncated?
See SQL Server 2005 Books Online topic:
float and real (Transact-SQL)
http://msdn2.microsoft.com/en-us/library/ms173773.aspx
|||Perfect.
thanks for your help.
No comments:
Post a Comment