Why does SQL Server round off results of dividing two integers?

by

When you do integer division (integer divided by integer) you always get an integer answer. 50/100 = .50, which is 0 in integer-speak.

Have you tried dividing MY_COLUMN by 100.0?

More Related Contents:

  1. Truncate (not round) decimal places in SQL Server
  2. Case statement for multiple columns
  3. SQL where clause odd behavior [closed]
  4. SQL Server Exec issue [closed]
  5. Count(*) vs Count(1) – SQL Server
  6. How do I escape a single quote in SQL Server?
  7. Selecting data from two different servers in SQL Server
  8. Is a view faster than a simple query?
  9. How to convert DateTime to VarChar
  10. How to rewrite IS DISTINCT FROM and IS NOT DISTINCT FROM in SQL Server 20008R2?
  11. How do I delete from multiple tables using INNER JOIN in SQL server
  12. SQL : BETWEEN vs =
  13. SQL Server: Howto get foreign key reference from information_schema?
  14. SQL Server convert string to datetime
  15. Should I design a table with a primary key of varchar or int?
  16. How do you import a large MS SQL .sql file?
  17. How do I make a composite key with SQL Server Management Studio?
  18. Difference between Subquery and Correlated Subquery
  19. How to execute .sql file using powershell?
  20. Return number of rows affected by UPDATE statements
  21. Execute Dynamic Query with go in sql
  22. TransactSQL to run another TransactSQL script
  23. How can I get a list of element names from an XML value in SQL Server
  24. SQL server identity column values start at 0 instead of 1
  25. Syntax of for-loop in SQL Server
  26. Using tuples in SQL “IN” clause
  27. Why does ISNUMERIC(‘.’) return 1?
  28. What does ON [PRIMARY] mean?
  29. SQL query to group by day
  30. Getting warning: Null value is eliminated by an aggregate or other SET operation

Leave a Comment