Why is casting from float to varchar being rounded in SQL Server?

by

Also from your link (it’s actually the first line):

Approximate-number data types…

If you want exact precision, don’t use float.

That being said, there is a function STR() specifically for converting float to a character data type.

More Related Contents:

  1. T-SQL: Opposite to string concatenation – how to split string into multiple records [duplicate]
  2. What is the best way to create and populate a numbers table?
  3. Sql Server string to date conversion
  4. SQL Server query to find all permissions/access for all users in a database
  5. How to get Time from DateTime format in SQL?
  6. Natural (human alpha-numeric) sort in Microsoft SQL 2005
  7. SQL Server IN vs. EXISTS Performance
  8. Cannot truncate table because it is being referenced by a FOREIGN KEY constraint?
  9. How much size “Null” value takes in SQL Server
  10. SQL Server Pivot Table with multiple column aggregates
  11. PIVOT in sql 2005
  12. What is the maximum characters for the NVARCHAR(MAX)? [duplicate]
  13. Atomic UPSERT in SQL Server 2005
  14. Do I really need to use “SET XACT_ABORT ON”?
  15. SQL Server sp_msforeachtable usage to select only those tables which meet some condition
  16. Is it possible to force row level locking in SQL Server?
  17. SQL Server ORDER BY date and nulls last
  18. SQL Server – Dynamic PIVOT Table – SQL Injection
  19. How to remove accents and all chars a..z in sql-server?
  20. How to query values from xml nodes?
  21. How to query for Xml values and attributes from table in SQL Server?
  22. Unable to begin a distributed transaction
  23. What happens to the primary key Id when it goes over the limit?
  24. What is the point of “Initial Catalog” in a SQL Server connection string?
  25. How do you kill all current connections to a SQL Server 2005 database?
  26. SQL Server recursive query
  27. Milliseconds wrong when converting from XML to SQL Server datetime
  28. nvarchar(max) vs NText
  29. Difference between database and schema
  30. Forgot SQL Server Password

Leave a Comment