Decimal values in SQL for dividing results

by

Just another approach:

SELECT col1 * 1.0 / col2 FROM tbl1

Multiplying by 1.0 turns an integer into a float numeric(13,1) and so works like a typecast, but most probably it is slower than that.

A slightly shorter variation suggested by Aleksandr Fedorenko in a comment:

SELECT col1 * 1. / col2 FROM tbl1

The effect would be basically the same. The only difference is that the multiplication result in this case would be numeric(12,0).

Principal advantage: less wordy than other approaches.

More Related Contents:

  1. T-SQL: Opposite to string concatenation – how to split string into multiple records [duplicate]
  2. Check if table exists in SQL Server
  3. Sql Server string to date conversion
  4. Simulation of CONNECT BY PRIOR of Oracle in SQL Server
  5. SQL Server query to find all permissions/access for all users in a database
  6. Cannot truncate table because it is being referenced by a FOREIGN KEY constraint?
  7. What is the maximum characters for the NVARCHAR(MAX)? [duplicate]
  8. Do I really need to use “SET XACT_ABORT ON”?
  9. Creating audit triggers in SQL Server
  10. Regular Expressions in SQL Server servers?
  11. How to determine total number of open/active connections in ms sql server 2005
  12. How to remove accents and all chars a..z in sql-server?
  13. Find non-ASCII characters in varchar columns using SQL Server
  14. How to query values from xml nodes?
  15. Diagnosing Deadlocks in SQL Server 2005
  16. How to query for Xml values and attributes from table in SQL Server?
  17. Disadvantages of MARS (Multiple Active Result Sets)?
  18. Violation of UNIQUE KEY constraint on INSERT WHERE COUNT(*) = 0 on SQL Server 2005
  19. Aggregate bitwise-OR in a subquery
  20. sql use statement with variable
  21. SQL Server recursive query
  22. nvarchar(max) vs NText
  23. Cannot find either column “dbo” or the user-defined function or aggregate “dbo.Splitfn”, or the name is ambiguous
  24. Date range overlapping check constraint
  25. Bulk insert fixed width fields
  26. Does query plan optimizer works well with joined/filtered table-valued functions?
  27. Difference between database and schema
  28. What are row, page and table locks? And when they are acquired?
  29. Cross Domain SQL Server Logins Using Windows Authentication
  30. Forgot SQL Server Password

Leave a Comment